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 the n'th highest salary from emp ?

Answer Posted / bharath

select e1.* from emp e1
where &n=
(select count(distinct(*))
from emp e2
where e2.sal>e1.sal);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is columnar storage what is the advantage?

1063


How to use group functions in the select clause using oracle?

1072


how to clone 9i Database on to 10g Database.

2339


How to use select statement to count the number of rows in oracle?

1044


how to do daily transactions with out sql* loader control file regesterd in apps?

1687


What is a system tablespace and when it is created?

972


what is port in oracle? how is it related to database application.

1949


What is a package ? What are the advantages of package ?

1091


How to create a new view in oracle?

1078


Explain enable novalidate constraint.

1081


What is the minimum client footprint required to connect c# to an oracle database?

1093


What are the differences between number and binary_float in oracle?

1100


How to convert times to characters in oracle?

1027


How many types of database triggers exist?

1135


What does sharding mean?

1000