SQL Select Statement
Table Of Contents:
- What Is SQL SELECT?
- SELECT Syntax.
- SELECT Examples.
(1) What Is SQL Select
- We use the “SELECT” statement to retrieve data from the database.
- The data returned is stored in a result table, called the result set.
(2) SELECT Syntax
SELECT column1, column2, ...
FROM table_name;
(3) SELECT Examples
Demo Dataset:
Example-1:
SELECT CustomerName, City FROM Customers;
Example-2:
SELECT CustomerName, City FROM Customers;
Example-3:
SELECT PostalCode FROM Customers;