Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which storage engine is best in mysql?

1010

How do I view mysql logs?

935

What is definer in mysql?

1011

What is myisam?

1033

What is row?

1151

Can we rename database in mysql?

1002

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

1100

What is mysql sleep process?

1083

How to check if a record exists in a mysql database php?

940

How many columns can be used for creating Index?

1108

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1186

How do I restore a mysql database dump file in linux?

1041

How to use mysqldump to create a copy of the database?

1147

What are the advantages of mysql in comparison to oracle?

1074

Is mysql from oracle?

1021