My 2 Cents The Select Statement

Swati Mishra

Yellow Belt
The SELECT statement is used to access and retrieve data from a database. The SELECT Statement prompts the server to query a single or multiple tables in the database and return it to the client application. The keyword SELECT, FROM and WHERE make a basic select statement.
Syntax

SELECT[ALL/DISTINCT] select_column_list
[INTO[new_table_name]]
FROM[table_name/view_name][(optimizer_hints)]
WHERE clasue
 

Manish Mishra

Yellow Belt
The select statement is the key feature of the SQL language. You cannot fire any query without the select statement. It is used in various queries made to retrieve, edit, delete a database.
 

Swati Mishra

Yellow Belt
The select statement is the key feature of the SQL language. You cannot fire any query without the select statement. It is used in various queries made to retrieve, edit, delete a database.
SELECT statement is used everywhere in SQL commands with the FROM and WHERE statement, when they three meet then make the SELECT statement.
 
Top