Interested to Buy Any Domain ? << Click Here >> for more details...
how to select second mauximum value in a given table under salary column
- 6 Answers
- 9725 Views
- Sapient, I also Faced
- E-Mail Answers
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
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Explain the use of analyse option in exp command.
How to calculate date and time differences in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
How to invoke the original export import utilities?
When do you get a .pll extension in oracle?
How to drop an existing table in oracle?
Explain self joins in oracle?
Briefly explain what is literal? Give an example where it can be used?
How to create lov dynamically at runtime & attach to text field?
Difference between the “verify” and “feedback” command?
How do we create privileges in oracle?
Explain temporal data types in oracle
How do I learn what codesets are available in oracle?
How to update values in a table in oracle?
