SQL Query to limit number of records in select query

SQL Query to select N number of records from database using select query.
set rowcount 10
Select * from EMP_TABLE