SQL Select Top

 

 

Select Top statement is use to return desire record.

SELECT TOP number or percent

FROM table_name

WHERE condition.

Return top 3 record from Customer Table:

SELECT TOP 3

FROM Customer.

Return top 10 record from Customer Table whose Username = 'abc' :

SELECT TOP 10

FROM Customer

where Username = 'abc'