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.
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