how to check the 3rd max salary from an employee table?
- 23 Answers
- 33832 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kumar sumit
select max(sal) from emp where sal not in(select max(sal)
from emp where sal not in(select max(sal) from emp))
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Can a key be both primary and foreign?
How do I create a sql script?
Name three sql operations that perform a sort.
how to shut down the server with 'mysqladmin'? : Sql dba
Can cursors be part of a trigger body?
How does cross join work?
what is error ora-03113: end-of-file on communication channel?
what is the difference between join and union? : Sql dba
What is basic structure of pl sql?
What are user defined functions?
What are tables in sql?
What is informix sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What do you mean by rowid?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
