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 rtm in testing?

1101

How do I write a sql query in pgadmin 4?

972

What problem one might face while writing log information to a data-base table in pl/sql?

1155

How many sql are there?

988

What is a left inner join?

1011

how many triggers are allowed in mysql table? : Sql dba

1059

Is primary key is clustered index?

996

When to use inner join and left join?

952

What is procedure and function?

974

What is data definition language?

1088

Which join is default?

948

what is a database transaction? : Sql dba

1169

Mention what pl/sql package consists of?

992

what are the type of locks ? : Sql dba

958

What is numeric function sql?

1054