SQL - Structured Query Language

SELECT Records



SELECT Statement is used to retrieves records from the database and enables the selection of one or many records or columns from one or many tables in SQL Server 2012.

SELECT Syntax

-- Syntax --

 

[ WITH <common_table_expression>]

 

SELECT select_list [ INTO new_table ]

 

[ FROM table_source ] [ WHERE search_condition ]

 

[ GROUP BY group_by_expression ]

 

[ HAVING search_condition ]

 

[ ORDER BY order_expression [ ASC | DESC ] ]


The UNION, EXCEPT and INTERSECT operators can be used between queries to combine or compare their results into one result set.

To Execute Query

Click Execute ICON from the Toolbar or Press F5 Key.

* * * * *


Email Your Comment To AUTHOR