Answers

Question and Answer:

  Home  MS SQL Server

⟩ How To Return the Top 5 Rows from a SELECT Query in MS SQL Server?

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 ggl_links:

SELECT TOP 5 id, url, counts, tag FROM ggl_links

ORDER BY counts DESC

GO

id url counts tag

102 www.rendc.org 972 DBA

105 www.google.com 960 DBA

107 www.yahoo.com 828 SQA

103 www.mysql.com 728 SQA

106 www.php.net 439 DEV

SELECT TOP 3 id, url, counts, tag FROM ggl_links

ORDER BY counts DESC

GO

id url counts tag

102 www.rendc.org 972 DBA

105 www.google.com 960 DBA

107 www.yahoo.com 828 SQA

 143 views

More Questions for you: