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

How do you edit data in pgadmin?

899


How do I connect to postgresql access?

1078


Does creating a foreign key create an index?

878


What is serial data type in postgresql?

949


What language is postgresql written in?

947


How do you remove a foreign key constraint?

844


What is a function in postgresql?

961


What is an example of a schema?

852


How big can postgres get?

872


What are the advantages of postgresql?

877


How do you create a table in pgadmin 4?

874


What is the latest version of postgresql?

915


Does postgresql have a gui?

855


What is the purpose of foreign key constraints?

923


What is postgresql dba?

974