Answer Posted / uday kiran
Its is like Nth highest salary.....
Select * from Employee where salary =
(Select max(Salary) from Employee where salary < (Select max
(Salary) from Employee where
Salary<(Select max(Salary) from Employee where
Salary <…………………………………………… N
| Is This Answer Correct ? | 15 Yes | 10 No |
Post New Answer View All Answers
What is %type in sql?
How many aggregate functions are available there in sql?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is function and procedure?
What is error ora-01000: maximum open cursors exceeded
What is difference between inner join and self join?
Can one improve the performance of sql*loader? : aql loader
What is the purpose of primary key?
What is scope and visibility in PL/SQL?
What is an implicit commit?
How do I find sql profiler?
How can I delete duplicate rows?
how to check server status with 'mysqladmin'? : Sql dba
What is trigger point?
What is difference between pls_integer and integer?