Wherever we have large tables with thousands of records we can use SELECT TOP Clause.
It limits the number of records in the query result set.
SELECT TOP : keyword used to fetch limited records in a table. (3 records in this case)
Table_name : The name of the table from where you want to fetch the data
Let’s query PersonalInfo table in our Demo Database to fetch only top 2 records.
Figure 18.1. SELECT * FROM PersonalInfo
Figure 18.2 Select Top 2 * from table_name;
Want More SQL Deep Dives