Find out the 3rd highest salary?
Answer Posted / durgashivashankar
select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why is sql*loader direct path so fast?
What is cartesian join in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Is join and inner join the same?
What is sql integrity?
What is pl sql package?
What is the difference between having clause and where clause?
Can a foreign key be a duplicate?
How to add, remove, modify users using sql?
What operating systems are supported by oracle sql developer?
What are types of joins?
What is java sql package?
How are functions and procedures called in PL/SQL?
Is it possible to read/write files to-and-from PL/SQL?
Explain what is a database?