Collections:
"TOP" - Return the Top 5 Rows from a SELECT Query in SQL Server
How To Return the Top 5 Rows from a SELECT Query in SQL Server?
✍: FYIcenter.com
If you want the query to return only the first 5 rows, you can use the "TOP 5" clause. The TOP clause takes one parameter to indicate how many top rows to return. The following statements returns the first 5 rows and 3 rows from the fyi_links:
SELECT TOP 5 id, url, counts, tag FROM fyi_links ORDER BY counts DESC GO id url counts tag 102 dba.fyicenter.com 972 DBA 105 www.oracle.com 960 DBA 107 www.winrunner.com 828 SQA 103 sqa.fyicenter.com 728 SQA 106 www.php.net 439 DEV SELECT TOP 3 id, url, counts, tag FROM fyi_links ORDER BY counts DESC GO id url counts tag 102 dba.fyicenter.com 972 DBA 105 www.oracle.com 960 DBA 107 www.winrunner.com 828 SQA
⇒ Returning the Second 5 Rows from a Query in SQL Server
⇐ Counting Groups Returned with the GROUP BY Clause in SQL Server
⇑ Using SELECT Statements with Joins and Subqueries in SQL Server
2016-10-29, 1718🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...