MS SQL Server Concepts and Programming Question: Download MS SQL Server PDF
What Is a SELECT Query Statement in MS SQL Server?
Answer:
The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. SELECT statements allows you to retrieve data from one or more tables or views, with different selection criteria, grouping criteria and sorting orders.
A SELECTE statement has the following basic syntax:
<pre>
SELECT select_list
FROM table_source
WHERE search_condition
GROUP BY group_by_expression
HAVING search_condition
ORDER BY order_by_expression
</pre>
Here is an example of a SELECT statement with all clauses mentioned above:
<pre>
SELECT SalesOrderID, SUM(LineTotal) AS TotalPrice
FROM SalesLT.SalesOrderDetail
WHERE ModifiedDate > '2004-05-01'
GROUP BY SalesOrderID
HAVING COUNT(*) > 30
ORDER BY TotalPrice DESC
</pre>
A SELECTE statement has the following basic syntax:
<pre>
SELECT select_list
FROM table_source
WHERE search_condition
GROUP BY group_by_expression
HAVING search_condition
ORDER BY order_by_expression
</pre>
Here is an example of a SELECT statement with all clauses mentioned above:
<pre>
SELECT SalesOrderID, SUM(LineTotal) AS TotalPrice
FROM SalesLT.SalesOrderDetail
WHERE ModifiedDate > '2004-05-01'
GROUP BY SalesOrderID
HAVING COUNT(*) > 30
ORDER BY TotalPrice DESC
</pre>
| Previous Question | Next Question |
| How To Use ORDER BY with UNION Operators in MS SQL Server? | How To Select All Columns of All Rows from a Table with a SELECT statement in MS SQL Server? |