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

Why foreign key constraint is important?

854


Does postgres create indexes for foreign keys?

940


Can primary key be null postgres?

872


What is postgresql? Explain the history of postgresql.

941


What is a postgres tuple?

937


Provide a brief explanation of the functions in postgresql.

844


What is the best postgresql gui tool?

874


What is the point of foreign keys?

821


How large can a postgresql database be?

874


Does postgres have clustered index?

848


What is the difference between oracle and postgresql?

1006


How to connect to postgres database using pgadmin?

952


What is special about postgresql?

863


How do you change the name of a column?

843


Is postgresql free to use?

833