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 is on delete restrict?
How many types of relationship are there?
What is the difference between numeric and autonumber?
how to return query output in html format? : Sql dba
Why do you partition data?
What is the sql query to display the current date?
Does truncate require commit?
What are database links used for?
What are triggers in sql?
Does inner join remove duplicates?
How to run sql functions in pl/sql?
What do we need to check in database testing?
what is subquery? : Sql dba
What is a sql trace file?
How do you clear the screen in sql?