find out the third highest salary?
Answer Posted / siddharth mitra
select *
from (select row_number() over (order by salary asc) as
"ROW_NUM" from emp)
where ROW_NUM = 3;
This only works with oracle 8i and 9i,i.e., row_number is an
analytic function.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a parameter file in oracle?
How to insert multiple rows with one insert statement in oracle?
What is Virtual Private Database in Oracle?
How can we find out the current date and time in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How can we create the complete backup of data in the oracle.
Can group functions be mixed with non-group selection fields?
What is integrity and what is constraint??Explain with example
Explain an extent?
What is oracle used for?
How many categories of data types in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
Explain overloading. Can functions be overloaded?
Why do you use stored procedures and state some of its disadvantages?
How do you store pictures in a database?