SQL SELECT Statement

Sql Select Query Syntax

The below syntax is used to select specific column(s) from the specific table.

SELECT 
column_name1, column_name2, column_nameN 
FROM table_name;

The below syntax is used to select all column(s) from the specific table.

SELECT * FROM table_name;

Note:- You can write all SQL statements in a single line or multiple line.

• SELECT - The SELECT command specifies the list of columns that are retrieved from the table.
• FROM - The FROM command specifies from where data should be retrieved.

Sample Database Table - Books

SELECT Specific Column Example

The following SQL SELECT statement selects the "BookName" and "BookPrice" columns from the "Books" table:

SELECT 
BookName, BookPrice 
FROM Books;

Note: Column names are separated by commas(,).

The result of above query is:

SELECT * Example

The following SQL SELECT statement selects all the column names or fields of "Books" table:

SELECT * FROM Books;

Note: '*' is a special characters, which is used to select all columns from the table.

The result of above query is: