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 / mohd javed

For All SQL , Tested in PostgresSQL : Javedcc@gmail.com

SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM
<Table_Name> B WHERE A.Column_Name >= B.Column_Name)

Is This Answer Correct ?    8 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is connection pooling in postgresql?

906


Is pgadmin open source?

795


How do you insert rows and columns?

786


How many indexes per table are allowed in postgresql?

855


Where is psql data stored?

824


How will you add a new style in a table?

802


What is aws aurora postgres?

802


What is the driver name for postgresql?

810


How to get current date in postgresql?

985


Does drop table also drop indexes?

776


Why do we need connection pooling?

802


How do I connect to postgresql database from windows?

841


What is postgresql written in?

923


Can we add foreign key without primary key?

886


Where are postgres databases stored?

917