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 do you think about pl/sql?

1041

What is numeric function sql?

1068

What are different types of functions in sql?

1008

Which query operators in sql is used for pattern matching?

970

Does truncate release storage space?

1085

write an sql query to find names of employee start with 'a'? : Sql dba

1030

What are sql indexes?

1004

how to concatenate two character strings? : Sql dba

1106

What is function and procedure in pl sql?

1050

What is output spooling in sql*plus?

1041

Explain the difference between 'between' & 'and' operators in sql

1004

How do I run a sql query in pgadmin 4?

966

how would you enter characters as hex numbers? : Sql dba

991

Which is faster count (*) or count 1?

1038

How do I run a sql script?

1157