T-SQL Tutorials - TSQLTutorials.com

TOP Option


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


Microsoft SQL Server 2014 Standard Edition Server w/20 CAL’s

Price: $641.99
Buy It Now
SQL Server 2014 Standard Edition, 32bit & 64bit, Media & License w/25CAL

Price: $549.99
Buy It Now
MSFT SQL Server 2016 Standard Edition x64 64bit | Full Edition |Original| 25CAL

Price: $999.99
Buy It Now
MSFT SQL Server 2016 Standard Edition x64 64bit | Full Editon | Original | 10CAL

Price: $549.99
Buy It Now
MSFT SQL Server 2008 R2 Enterprise Edition 25 CAL 32/64-Bit

Price: $299.99
Buy It Now
MSFT SQL Server 2008 R2 Standard Edition 32/64-Bit 10 CAL Edition

Price: $224.99
Buy It Now







Copyright 2017 - TSQLTutorials.com