Find out the 3rd highest salary?
Answer Posted / dharmendra yadav
select min(salary) from (select name , salary , rownum from
Emp order by salary desc) where rownum <= 3 ;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How many joins in sql?
How do I add a database to sql?
What does seeding a database mean?
What is sql exception?
What is pessimistic concurrency control? : Transact sql
What is difference between sql and oracle?
What is sqlservr exe?
How do you identify a primary key?
How many subqueries can be nested in a statement?
How can I delete duplicate rows?
how to enter characters as hex numbers? : Sql dba
What is trigger point?
what is cursor. write example of it. What are the attributes of cursor.
What is trigger price?
what are the t string functions available in tsql? : Transact sql