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, 1315🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...