Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147692 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
How to revoke create session privilege from a user in oracle?
What is a user role in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to use regular expression in pattern match conditions in oracle?
How to assign a table row to a record variable?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to view existing locks on the database?
What are the limitations of check constraint?
Can we store images in oracle database?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is meant by raw datatype?
How a tablespace is related to data files?
What is the disadvantage of User defind function?
How to apply filtering criteria at group level in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
