Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151196 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / nagaraj a h
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is the recommended interval at which to run statspack snapshots, and why?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to do clean up if create database failed?
How to call a stored function in oracle?
How to use windows user to connect to the server?
What is BBED in Oracle?
Is oracle a programming language?
How to declare a local variable?
What are the general rules on data consistency?
Does oracle database need java?
Explain what are the uses of rollback segment?
Design database draw er diagram for a certain scenario ?
