SQL SELECT Keyword
The SELECT command is used to retrieve data from a database. The returned data is stored in a result table, called the result set.
SQL SELECT Syntax
SQL
x
1
SELECT column1, column2, ...
2
FROM table_name;
SQL SELECT Specific Columns Example
This query selects the first_name
and last_name
columns from the Patients
table.
SQL
1
1
SELECT first_name, last_name
2
FROM Patients;

SQL SELECT All Columns Example
This query selects all columns from the Patients
table.
SQL
1
1
SELECT *
2
FROM Patients;
