Basic Select Syntax
To select data from a single table, we use the syntax
SELECT column_names_or_other_information
[AS alias]
[ORDER BY column(s)] [DESC]
FROM table_name
[WHERE condition];
Let’s look at some examples.
To select data from a single table, we use the syntax
SELECT column_names_or_other_information
[AS alias]
[ORDER BY column(s)] [DESC]
FROM table_name
[WHERE condition];
Let’s look at some examples.