TL;DR – The SQL SELECT command is commonly used for search queries. Using it, you can select specific data from your SQL databases. The data you select is stored in a table called a result-set.
Contents
Syntax of SQL SELECT
Selecting specific columns
SELECT column1, column2, ...
FROM table_name;
Selecting all columns
SELECT * FROM table_name;

- Simplistic design (no unnecessary information)
- High-quality courses (even the free ones)
- Variety of features
- Nanodegree programs
- Suitable for enterprises
- Paid certificates of completion

- Professional service
- Flexible timetables
- A variety of features to choose from
- Professional certificates of completion
- University-level courses
- Multiple Online degree programs

- Great user experience
- Offers quality content
- Very transparent with their pricing
- Free certificates of completion
- Focused on data science skills
- Flexible learning timetable
Examples using a demo database
The Users table
ID | Username | Password | |
---|---|---|---|
1 | alfredfutter | [email protected] | secret1 |
2 | atrujillo | [email protected] | secret2 |
3 | moreno.antonio | [email protected] | secret3 |
4 | hardythomas | [email protected] | secret4 |
5 | bergluns | [email protected] | secret5 |
Using SELECT to retrieve data of specific columns
Using SELECT to retrieve data of all columns
Note: SELECT * selects all columns, SELECT ALL selects all rows.
Latest Udacity Coupon Found:
75% OFF COURSES
Udacity Black Friday Offer
The best time to save on Udacity courses is now - follow this coupon to access a 75% Udacity Black Friday discount & enjoy learning at a very low cost!