T-SQL Tutorials - TSQLTutorials.com
TOP Option
- SQL Bookstore
- Home - Introduction
- BASIC
- Tables, Columns, Rows
- SELECT Statement
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- WHERE Clause
- TRUNCATE Statement
- GROUP BY
- HAVING
- Aggregation Functions
- DISTINCT
-
- INTERMEDIATE
- T-SQL Operators
- T-SQL Variables
- T-SQL Data Types
- CREATE TABLE
- CREATE PROCEDURE
- CREATE FUNCTION
- CREATE INDEX
- SQL JOIN
- SQL OUTER JOIN
- What is an index?
- CAST / CONVERT
- COALESCE
- Aliases
- CASE .. WHEN
- Working with Dates
- Working with Strings
- ADVANCED
- Cursors
- WHILE Loop
- TOP
- PIVOT
- UNPIVOT
- SQL_VARIANT
- TRY CATCH Blocks
- WITH
- XML
- UNION
- INTERSECT
- EXCEPT
- Other Functions
-
- Partners
- Document SSIS Packages
- SSIS Tutorials
- Information
- Privacy Policy
Introduction
The TOP option is used for limiting the output of a query result set. The TOP SQL Statement is often used with the SELECT statement. TOP can either specify the number of rows to return, or the precentage of rows to return. The ORDER BY clause can be used successfully with the TOP option. In other words, the ORDER BY will be completed before the rows are limited.
Using TOP with SELECT Statements
Syntax for returning n number of rows:
SELECT TOP n *FROM table
Example for returning 10 rows:
SELECT TOP 10 *FROM employees
Syntax for returning n percentage of rows:
SELECT TOP n PERCENT *FROM table
Example for returning 20 percent of rows:
SELECT TOP 20 PERCENT *FROM employees
Using TOP with SELECT Statements using ORDER BY clause
Example for returning top 10 highest paid employees:
SELECT TOP 10 *FROM employees
ORDER BY Salary DESC
|
|
|
|
|
|
