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 kind of database is postgres?

743


What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases?

1543


Is postgres distributed?

718


What is pg pool?

774


Does postgres automatically index primary key?

726


How do I drop a table in postgresql?

765


Is edb postgres free?

745


Is postgresql scalable?

757


How do I delete a query?

716


How do you edit a table in pgadmin?

707


What is rds instance?

755


How do I rename a column in postgresql?

839


Compare ‘postgresql’ with ‘nosql’?

795


Which are different types of database administration tools used in postgresql?

833


Explain multi version concurrency control.

864