Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / satish
select rownum,employee_id,first_name,max(salary) from
employees
group by rownum,employee_id,first_name
having rownum<=2
order by rownum
Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
How do I view a procedure in sql?
What has stored procedures in sql and how we can use it?
What are the properties of a transaction?
What's the difference between inner join and left join?
What will you get by the cursor attribute sql%found?
What is faster join or subquery?
Which are the different character-manipulation functions in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is difference between my sql and sql?
What problem one might face while writing log information to a data-base table in pl/sql?
what are the 'mysql' command line options? : Sql dba
What is cold data?
Which join is default?
How do you drop a trigger?
what are the advantages a stored procedure? : Sql dba