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, 1306🔥, 0💬
Popular Posts:
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...