select rownum,employee_id,first_name,max(salary) from employees group by

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / satish

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

Please Help Members By Posting Answers For Below Questions

What is the basic structure of an sql?

1098

What does := mean in pl sql?

1040

What is equi join in sql?

1069

What language is oracle sql developer?

1005

Is primary key clustered or nonclustered?

1012

What do you mean by field in sql?

1075

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

987

What does <> sql mean?

1081

what are the types of subquery? : Sql dba

1102

what is the different between now() and current_date()? : Sql dba

1016

What is the purpose of the partition table?

1047

What is sql basics?

1038

How delete all data from table in sql?

1014

What are the types of operators available in sql?

1060

how is exception handling handled in mysql? : Sql dba

1075