find out the second highest salary?
Answer Posted / sikindar
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 | 0 No |
Post New Answer View All Answers
Explain about the analyze command in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to select all columns of all rows from a table in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What are the advantages of oracle 12c?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is sequence?
Explain the use of ignore option in imp command.
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
 What are the oracle DML commands possible through an update strategy?
What is an oracle data file?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Is a rollback possible to any savepoint?
What is tns service name?
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.