how to calcuate the second highest salary of he employee
Answer Posted / shailesh
select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp);
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Compare sql & pl/sql
Is sql an operating system?
How to add, remove, modify users using sql?
What is the most restrictive isolation level? : Transact sql
Which are the different character-manipulation functions in sql?
What is sql mysql pl sql oracle?
What is the difference between having clause and where clause?
What are the different set operators available in sql?
Why cross join is used?
What are types of indexes in sql?
How do I restart sql?
What is primary key secondary key alternate key candidate key?
Explain the working of foreign key?
what is the difference between where clause and having clause? : Sql dba
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?