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 I add a primary key in pgadmin?

758


How do you delete a row in a table?

710


What is bytea in postgres?

774


Can you store images in postgres?

721


Are foreign key constraints necessary?

776


What happens to index when table is dropped?

774


What is pgadmin 4 written in?

725


What does mvcc mean?

786


How do I enable postgis on pgadmin?

871


What is multi-version control?

759


How do you delete a column?

775


What is the default postgres database?

783


Is postgresql better than sql server?

848


What is postgresql?

847


Does postgres use sql?

782