Find out the 3rd highest salary?
Answer Posted / divya c
Select max(sal) from emp
where sal<(select max(sal) from emp where sal<(select max
(sal) from emp));
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the various levels of constraints?
What is sql not null constraint?
What is the purpose of cursors in pl/sql?
What is a recursive stored procedure?
What is Histogram?
Is it possible to create the following trigger: before or after update trigger for each row?
Why do we use joins?
How can I speed up sql query?
What is the difference between sum and count in sql?
What are records give examples?
what is sp_pkeys? : Transact sql
explain commit and rollback in mysql : sql dba
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
When sql appeared?
Which certification is best for sql?