Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153770 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / karunakar varma
select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How do I escape a reserved word in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to delete multiple rows from a table in oracle?
What are the general rules on data consistency?
What operating systems are supported by oracle database 10g xe?
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?
Can we write insert statement in function in oracle?
How do I manually uninstall oracle client?
What are the most common interview questions on ETL Testing for experience?
Explain the features of oracle?
How would you change old and new values in an insert, delete and update triggers?
How many types of table in Oracle?
What is the data pump export utility?
What is oracle and what are its different editions?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
