My 2 Cents The Select And The Where Statement

Swati Mishra

Yellow Belt
The SELECT statement is used everywhere in the query with the WHERE statement both are used for the retrieve the information from the database and display it.
Syntax

SELECT column_list
FROM table_name
WHERE search_condition

where search condition may be any search condition.
 

Manish Mishra

Yellow Belt
Select and where statement used to filter the data retrieval from a table. Select is use for selection of a particular table and where is used for set of condition to be followed while retrieving the data from a table.
 

Swati Mishra

Yellow Belt
Select and where statement used to filter the data retrieval from a table. Select is use for selection of a particular table and where is used for set of condition to be followed while retrieving the data from a table.
SELECT and WHERE statement filter the data retrieval from the table but it is select all data from the table according to query also.
 
Top