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 / ezhumalai

with cte
as
(
select Salary,row_number() over ( order by Salary asc)rnt from EMP
)select * from cte where rnt=2

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Who invented postgresql?

838


What is pgrouting?

792


What is logical replication in postgresql?

1002


What ports does postgresql use?

887


What command do you type to exit the postgresql console application?

862


What is the difference between sql and postgresql?

917


Is sql a postgresql?

946


How do you change the name of a column?

804


How do I connect to pgadmin?

878


What are the rules of setting a primary key?

830


What is cluster control?

836


What is psql command?

986


What is foreign key in java?

842


How does pgadmin connect to remote database?

985


What is postgresql client?

951