i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
Answer Posted / obulesu
select * from (select e.*,dense_rank() over(order by sal desc) r from emp e) where r=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
State some uses of redo log files?
various types of hints and their usage
How to use attributes of the implicit cursor in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What is the disadvantage of User defind function?
What is the difference between translate and replace in oracle?
How many types of synonyms in Oracle?
How do I escape a reserved word in oracle?
What is the usage of control file in oracle?
what are steps for interface? where is exchange rate defined in which table?
How will you differentiate between varchar & varchar2?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is the order of defining local variables and sub procedures/functions?
What is ceil and floor in oracle?
How can we find out the duplicate values in an oracle table?