TOP Clause

Limits the number of Rows in the result set based on criteria or percentage specified


Select TOP 3 * From EMP_DATABASE

Select TOP 20 Percent * From EMP_DATABASE