SQL TOP Clause

The TOP clause in SQL is used to fetch the limited result from the table. It is often used when dealing with larger databases and tables.

  • Syntax of TOP Clause – 

SELECT TOP value column1,column2,...,columnN FROM table_name WHERE condition ;

 

OR,

  • Syntax of TOP (percent) Clause – 

SELECT TOP value PERCENT column1,column2,...,columnN FROM table_name WHERE condition;

 

Demo table –

Product Table 

Category

Region

City

Country

Customer_ID

Customer_name

Office Supplies

West

Chicago

United States

SM-20950

Suzanne McNair

Technology

Central

New York City

United States

AH-10465

Amy Hunt

Office Supplies

East

New York City

United States

AH-10465

Amy Hunt

Office Supplies

East

Dover

United States

EP-13915

Emily Phan

Office Supplies

East

Dover

United States

EP-13915

Emily Phan

Technology

East

Aurora

United States

TP-21565

Tracy Poddar

Office Supplies

West

Aurora

United States

TP-21565

Tracy Poddar

Office Supplies

West

Long Beach

United States

AR-10825

Anthony Rawles

Office Supplies

East

Pasadena

United States

HA-14920

Helen Andreada

Furniture

West

Pasadena

United States

HA-14920

Helen Andreada

 

Example – Using the TOP CLAUSE, retrieve the top 2 from the demo table where the Region is “West”.

SELECT TOP 2 * FROM [dbo].[Products] WHERE Region = 'West';

 

The output after implementing the above TOP CLAUSE –

Category

Region

City

Country

Customer_ID

Customer_name

Technology

West

Aurora

United States

TP-21565

Tracy Poddar

Office Supplies

West

Aurora

United States

TP-21565

Tracy Poddar

 

Example – Using the TOP PERCENT CLAUSE, retrieve the top 50% records from the demo table where the Region is “West”.

SELECT TOP 50 PERCENT * FROM [dbo].[Products] WHERE Region = 'West';

 

The output after implementing the above TOP PERCENT CLAUSE –

Category

Region

City

Country

Customer_ID

Customer_name

Technology

West

Aurora

United States

TP-21565

Tracy Poddar

Office Supplies

West

Aurora

United States

TP-21565

Tracy Poddar

Office Supplies

West

Pasadena

United States

HA-14920

Helen Andreada

Furniture

West

Pasadena

United States

HA-14920

Helen Andreada

Office Supplies

West

Mesa

United States

HJ-14875

Heather Jas

 

Other SQL topics to check out:

Follow us on TwitterFacebook, Linkedin, and Tableau Public to stay updated with our latest blog and what’s new in Tableau.

If you are looking forward to getting your data pipeline built and setting up the dashboard for business intelligence, book a call now from here.

#analytics #data #business #artificialintelligence #machinelearning #startup #deeplearning #deeplearning #datascience #ai #growth #dataanalytics #india #datascientist #powerbi #dataanalysis #tableau #SQL #businessanalytics #businessanalyst #businessandmanagement #dataanalyst #businessanalysis #analyst #analysis #powerbideveloper #powerbidesktop #letsviz