Introduction
In this article, we will learn how to use the TOP Clause with a SQL select query.
The SELECT TOP clause is used to specify the number/percent of records to return.
The SELECT TOP clause is useful with thousands of records on large tables.
Syntax
SELECT TOP number|percent column_name(s) FROM TABLE_NAME;
Example-1
The subsequent statement would return the first two records from the Article table.
SELECT TOP 2 * FROM Article;
Example-2
The subsequent statement would return the first 50% of the records from the Article table.
SELECT TOP 50 PERCENT * FROM Article;
Also, check How To Display SQL Data In Descending Order
