select salary from employee e1 where (n-1)=(select count(*) from employee

how we can find nth max salary from an employe table by
using my sql?

Question Posted / sumit

Answer Posted / sumit

select salary from employee e1
where (n-1)=(select count(*) from employee where
salary>e1.salary)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What happens if you no create privilege in a database?

1053

Is mysql a framework?

886

What are the types of index?

915

Is mysql a good database?

912

What is full text indexing in mysql?

915

How we can create index in mysql?

940

How does mysql encrypt passwords?

862

How can you make a database as your current database?

986

What is foreign key in mysql?

993

Why use mysql procedures?

947

What is append query?

879

How can I see connections in mysql?

883

What is mysqli_select_db?

930

How do I rename a table in mysql workbench?

926

What is the difference between unix timestamps and mysql timestamps?

978