Select Querie

SELECT

Syntax

SELECT "column_name" FROM "table_name"

To illustrate the above example, assume that we have the following table:

Table Shop



To select all the stores in this table, we key in,


SELECT store_name FROM Shop


Result

store_name
Kumar
Devi
Kumar
Saritha


Multiple column names can be selected, as well as multiple table names.