SQL > Advanced SQL > Top

The TOP keyword restricts the number of results returned from a SQL statement in Microsoft SQL Server.

Syntax

The syntax for TOP is as follows:

SELECT TOP [TOP argument] "column_name"
FROM "table_name";

where [TOP argument] can be one of two possible types:

1. [N]: The first N records are returned.

2. [M] PERCENT: The number of records corresponding to M% of all qualifying records are returned.

Examples

We use the following table for our examples.

Table Store_Information

Store_NameSalesTxn_Date
Los Angeles1500Jan-05-1999
San Diego250Jan-07-1999
San Francisco300Jan-08-1999
Boston700Jan-08-1999

Example 1: [TOP argument] is an integer

To show the two highest sales amounts in Table Store_Information, we key in,

SELECT TOP 2 Store_Name, Sales, Txn_Date
FROM Store_Information
ORDER BY Sales DESC;

Result:

Store_NameSalesTxn_Date
Los Angeles1500Jan-05-1999
Boston700Jan-08-1999

Example 2: [TOP argument] is a percentage

To show the top 25% of sales amounts from Table Store_Information, we key in,

SELECT TOP 25 PERCENT Store_Name, Sales, Txn_Date
FROM Store_Information
ORDER BY Sales DESC;

Result:

Store_NameSalesTxn_Date
Los Angeles1500Jan-05-1999

Next: SQL Subquery




Copyright © 2016   1keydata.com   All Rights Reserved     Privacy Policy     About   Contact