Code has been added to clipboard!

SQL SELECT and SELECT ALL Statements

Reading time 1 min
Published Jan 4, 2016
Updated Oct 9, 2019

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.

Syntax of SQL SELECT

Selecting specific columns

Example
SELECT column1, column2, ...
FROM table_name;

Selecting all columns

Example
SELECT * FROM table_name;
Udacity
Pros
  • Simplistic design (no unnecessary information)
  • High-quality courses (even the free ones)
  • Variety of features
Main Features
  • Nanodegree programs
  • Suitable for enterprises
  • Paid certificates of completion
Coursera
Pros
  • Professional service
  • Flexible timetables
  • A variety of features to choose from
Main Features
  • Professional certificates of completion
  • University-level courses
  • Multiple Online degree programs
Datacamp
Pros
  • Great user experience
  • Offers quality content
  • Very transparent with their pricing
Main Features
  • Free certificates of completion
  • Focused on data science skills
  • Flexible learning timetable

Examples using a demo database

The Users table

ID Username Email 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

Example
SELECT username,email 
FROM users;

Using SELECT to retrieve data of all columns

Example
SELECT * FROM users;

Note: SELECT * selects all columns, SELECT ALL selects all rows.

Latest Udacity Coupon Found:

Verified STAFF PICK

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!

Expiration date: 03/03/2021
3176 People Used
Only 97 Left
Rating
5.0