Sunday 15 June 2014

Fetch any number of heighest salary from table in mysql

You can fetch any number of heighest salary from table in mysql using following query -

select * from emp order by salary desc limit 0,1;

In above query emp is a table, salary is a column so when we change limit value like 0 or 1 or 2 it will be fetch heighest, second heighest, and third heighest and so on. Each red color word is a keword in mysql.

No comments:

Post a Comment