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
What is Redo Log Buffer in Oracle?
How to insert a record into a table?
How to connect to a remote server?
How many data types are supported?
How to check the server version in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to use regular expression in pattern match conditions in oracle?
Can we insert data in view oracle?
How to define a data source name (dsn) in odbc manager?
How to delete a user account in oracle?
Explain integrity constraint?
How to execute a stored program unit?
What are the types of trigger in oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What happens if you set the sga too low in oracle?