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 indexing oracle sql?
How do you pronounce sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What are the disadvantages of file system?
how do you know the version of your mysql server? : Sql dba
What are the basic sql commands?
What are the packages in pl sql?
what are the disadvantages of mysql? : Sql dba
How do I make sql search faster?
Is it possible to sort a column using a column alias?
What are the methods of filing?
Can a table have no primary key?
what is the difference between nested subquery and correlated subquery?
What is nosql db?
Is sql low level language?