Collections:
What Is a SELECT Query Statement in SQL Server
What Is a SELECT Query Statement in SQL Server?
✍: FYIcenter.com
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 SELETE statement has the following basic syntax:
SELECT select_list FROM table_source WHERE search_condition GROUP BY group_by_expression HAVING search_condition ORDER BY order_by_expression
Here is an example of a SELECT statement with all clauses mentioned above:
SELECT SalesOrderID, SUM(LineTotal) AS TotalPrice FROM SalesLT.SalesOrderDetail WHERE ModifiedDate > '2004-05-01' GROUP BY SalesOrderID HAVING COUNT(*) > 30 ORDER BY TotalPrice DESC
⇒ Testing Table for SELECT Statements in SQL Server
⇐ Using SELECT Statements and GROUP BY Clauses in SQL Server
⇑ Using SELECT Statements and GROUP BY Clauses in SQL Server
2016-10-26, 1392🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...