how to select second mauximum value in a given table under salary column
Answer Posted / utkal
Select distinct(E1.Salary) from EMPLOYEE E1 where 2 =
(Select Count(distinct(E2.Salary)) from Employe E2 where
E1.Salary <= E2.Salary).
Here n=2,
Similarily we can find the 5th highest salary etc...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I manually create a database in oracle?
How to concatenate two text values in oracle?
How to rebuild an index in oracle?
How to execute the package in oracle?
Explain the use of compress option in exp command.
Does oracle charge for java?
Difference between cartesian join and cross join?
Please explain oracle left join with an example?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Explain the difference between replace() and translate() functions in oracle?
Difference between the “verify” and “feedback” command?
State and explain about oracle instance?
Is it possible to insert comments into sql statements return in the data model editor ?
Explain the use of log option in exp command.