Select

SQL SELECT

The SELECT command is used to query a database table.
You can select all records or only certain records from an SQL table.

Syntax

SELECT * FROM name_of_table;
SELECT column1, column2 FROM name_of_table;

Example

SELECT * FROM students;
SELECT * FROM students WHERE student_id=1;