Learn how to use SQL SELECT statement with the tutorial and explained examples given here. Find out how to select or retrieve data using SQL SELECT statement.
You can use WHERE clause by which you can apply condition and select only the useful data from the table. In addition to this, learn how to order the retrieved data in ascending and descending orders.
Select multiple columns required to display on your application using the SQL query. This can be useful to develop many applications and fetch the data from the required table of the database.
How to Use SQL SELECT Statement to Retrieve Data
In the syntax given below, the WHERE and ORDER BY clause are optional. If you want to select only the required data with the required condition you can use the WHERE clause in your syntax.
The ORDER BY clause can be used when you want to order your retrieved data and display in ascending or descending order. You can select multiple columns or you can select all the columns using the (*) symbol in place of the column after SELECT.
Syntax1: Select all data.
|
1 2 |
SELECT * FROM tablename; |
The above syntax select and retrieve all the columns and its data from the table of the database.
Syntax2: Select All Using Conditional Statement.
|
1 2 3 |
SELECT * FROM tablename WHERE condition; |
The above syntax select all the columns using the condition to retrieve only the required data.
Syntax3: Select Required Columns only Using Conditional Statement.
|
1 2 3 |
SELECT column1, column2...columnN FROM tablename WHERE condition; |
Retrieve selected column data using the conditional statement to get the required data only.
Syntax4: Select Using Conditional Statement and order.
|
1 2 3 4 |
SELECT column1, column2...columnN FROM tablename WHERE condition ORDER BY column1, column2...columnN ASC|DESC; |
You can select multiple columns data and arrange its data in ascending or descending or using the ORDER BY clause.
Parameter Descriptions
| Sr.No | Parameter Name | Description |
|---|---|---|
| 1 | column1, column2…columnN | Enter the column name you want to select from the table. You can also use (*) to select all the columns from a table. |
| 2 | tablename | Specify the table from where you want to select and display the data. |
| 3 | condition | You can also specify the condition using which you can display or retrieve only the required data from the table. |
|
1 2 |
SELECT * FROM Employee; |
|
1 2 3 |
SELECT * FROM Employee WHERE Salary>25000; |
|
1 2 3 |
SELECT Name, Address, Designation FROM Employee WHERE Salary>25000; |
|
1 2 3 4 |
SELECT Name, Address, Designation FROM Employee WHERE Salary>25000 ORDER BY Name ASC; |
You must also learn.
Reference