Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151210 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / vishawjeet saini
SELECT MIN(sal) FROM emp WHERE
sal IN (select sal from emp order by sal desc limit 3)
Its works on almost databases including postgres.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is oracle database 10g express edition?
How to create a new tablespace in oracle?
What happens to the current transaction if the session is ended?
What is columnar storage what is the advantage?
Explain compound trigger in oracle?
Does oracle database need java?
Explain do view contain data?
How to Truncate Table in Oracle
Difference between cartesian join and cross join?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is a view and how is it different from a table?
How to convert raw data type into text in oracle? Explain
What are set operators?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to convert characters to times in oracle?
