Query for second maximum salary in each in each department
Answer Posted / sravan
Select first_name, salary, rownum rank from
(select *from emp order by salary desc)
Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What does t sql mean?
Can we use delete in merge statement?
What is case function?
how to use 'mysql' to run sql statements? : Sql dba
What is difference between hql and native sql?
Why triggers are used?
what are the types of join and explain each? : Sql dba
What is the difference between a primary key and a clustered index?
How to read xml file in oracle pl sql?
What is cascade in sql?
what is the difference difference between procedure and packages
How do you remove duplicates without using distinct in sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Is natural join same as inner join?