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...



how to find nth lowest salary

Answer Posted / hari.sidd

SELECT DISTINCT (A.sal) FROM EMP A WHERE &N =

(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B

WHERE a.sal>=b.sal);

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is shared_buffers postgresql?

901


How do I rename a column in postgresql?

920


What is write ahead logging in postgresql?

857


How do you remove a foreign key constraint?

809


Is postgresql free for commercial use?

811


What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?

1464


Is postgresql better than oracle?

825


Is mysql faster than postgresql?

776


Can postgresql run on windows?

903


What is pgadmin used for?

789


What is gis data?

781


How to drop a constraint in postgres?

831


Is postgresql better than mongodb?

839


What is pg pool?

849


What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?

1317