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 are different joins used in sql?
What is auto increment?
Explain the working of foreign key?
how do you know the version of your mysql server? : Sql dba
What is auto increment in sql?
explain the delete statements in sql
Can we update views in sql?
Can we insert data in view?
Where not exists in sql?
what is 'mysqld'? : Sql dba
What is the difference among union, minus and intersect?
What is difference between function and trigger?
What programs use sql?
How do you rename a table in sql?
what is view? : Sql dba