Select query with specific no of rows
Want to select 4 rows from the table;
Note: you can also used order by with this to find highest salary in table example.
select top 4 column_name from table_name;
select columnname from <table_name> where rownum <= 4;
MySQL and PostgreSQL
select columnname from <table_name> limit 4;