SELECT

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

SELECT column1, column2, ...
FROM table_name;

SELECT column1, column2, ...

FROM table_name;

SQL SELECT Specific Columns Example

This query selects the first_name and last_name columns from the Patients table.

SELECT first_name, last_name
FROM Patients;

SELECT first_name, last_name

FROM Patients;

SQL SELECT All Columns Example

This query selects all columns from the Patients table.

SELECT *
FROM Patients;

SELECT *

FROM Patients;

SQL SELECT Labs