how to check the 3rd max salary from an employee table?
Answer Posted / arjun
select min(sal) from (select sal from (select distinct(sal)
from emp order by sal desc) where rownum<4)
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How can use stored procedures in sql?
Does google use sql?
Does pl sql work in mysql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What are all the ddl commands?
What is database sql?
Cite the differences between execution of triggers and stored procedures?
What are the types of keys?
How is pl sql different from sql?
Can we use threading in pl/sql?
what is data manipulation language? : Sql dba
What is your daily office routine?
What are the key differences between SQL and PL SQL?
Define select, insert, create, delete, update, drop keywords
How do you rank data in sql?