select * from emp e1 where 2>(select count(1) from emp e2 whe

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

Question Posted / surajit pathak

Answer Posted / surajit pathak

select * from emp e1
where 2>(select count(1) from emp e2
where e2.sal>e1.sal)
order by sal desc

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

define sql delete statement ? : Sql dba

1026

what are rollup and cube in t-sql? : Transact sql

1106

explain advantages of myisam over innodb? : Sql dba

1073

What are joins in sql?

1050

What does sign mean sql?

1122

what are the authentication modes in sql server? : Sql dba

1073

What are the key differences between SQL and PL SQL?

1222

What are database links used for?

1052

What is nested table in pl sql?

1080

Is grant a ddl statement?

904

What is the execution plan in sql?

1035

What is string join?

982

Is a foreign key always unique?

950

What is the difference between row level and statement level trigger?

1031

what is cursor. write example of it. What are the attributes of cursor.

1402