Find out the 3rd highest salary?
Answer Posted / jagdish
select max(sal) from emp where sal!=(select max(sal) from
emp where sal!=(select max(sal) from emp))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is dcl in sql?
Is postgresql a server?
What is partition by in sql?
What are the events on which a database trigger can be based?
Why are aggregate functions called so?
What are the set operators in sql?
What is cte sql?
Which is faster union or join?
Explain the advantages and disadvantages of stored procedure?
Is ms sql is free?
What is data manipulation language?
What is the difference between a database and a relational database?
Explian rowid, rownum?
Explain what is a view?
what is view? : Sql dba