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 blob? : Sql dba

1222

How to sort the rows in sql.

1124

What are the two types of cursors in pl sql?

1125

What is sql keyword?

1046

How can I see all tables in sql?

1147

What is exception? What are the types of exceptions?

1115

how to convert character strings to dates? : Sql dba

1101

What is sql mysql pl sql oracle?

1129

Why do we create stored procedures & functions in pl/sql and how are they different?

995

i have some prob lem to tell me about my self in interview first round ...

2215

What is the current version of sql?

1070

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

What is sqlite used for?

1048

Is sql microsoft?

1108

What are expressions?

1062