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;