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:
![](https://www.praudyog.com/wp-content/uploads/2023/04/11-1024x390.jpg)
Example-1:
SELECT CustomerName, City FROM Customers;
![](https://www.praudyog.com/wp-content/uploads/2023/04/12-1024x314.jpg)
Example-2:
SELECT CustomerName, City FROM Customers;
![](https://www.praudyog.com/wp-content/uploads/2023/04/13-1024x326.jpg)
Example-3:
SELECT PostalCode FROM Customers;
![](https://www.praudyog.com/wp-content/uploads/2023/04/14-1024x282.jpg)