how to check the 3rd max salary from an employee table?
Answer Posted / akilis.org@hotmail.com
Let us Assume
Table Name=salary
Column Name=maxsal
select * from salary order by maxsal desc limit 2,1;
Enjoy the simple code :)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is procedure explain with example?
How to run pl sql program in mysql?
how to see the create table statement of an existing table? : Sql dba
How many types of privileges are available in sql?
Why is a trigger used?
What are schema-level triggers?
How many times can we commit in a loop?
How do I use google cloud in sql?
What is the basic form of sql query?
How do I make sql search faster?
What is mutating trigger?
Can we call stored procedure in function?
how to check server status with 'mysqladmin'? : Sql dba
What is foreign key in sql with example?
Why is sql important?