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

How many indexes per table are allowed in postgresql?

904


How do I connect to postgresql access?

1083


How do I open a pgadmin file in windows?

936


How do you create a table in pgadmin 4?

883


What is a table catalog?

821


What does truncate table do?

861


What is a schema in postgres?

849


How do I connect to pgadmin server?

982


How secure is postgresql?

949


What is serial data type in postgresql?

953


What is postgis and postgresql?

929


How do I connect to a postgresql database using sql developer?

909


How to check if postgres is running?

952


Is pgadmin open source?

851


What is postmaster in postgresql?

949