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
⇒Using SELECT Statements with Joins and Subqueries in SQL Server
2016-10-29, 629👍, 0💬
Popular Posts:
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...