Answer Posted / anilchandu
Select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal)
where x,y are alias names.
If you want 3rd heighest salary then just replace 2 by 3
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are a query and state the different types of queries and their uses?
What is data file?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is ordinary table in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are group functions in oracle?
What is using clause and give example?
What is a cursor variable?
How to convert times to characters in oracle?
What is a synonym? What are its various types?
how the indexes are stored in the Oracle Database?
Explain enable novalidate constraint.
How do I recompile a procedure in oracle?
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 bind variable in oracle 11g?
