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 / sunil panghal

select salary from emp where salary=(select max(salary)
from emp)

Is This Answer Correct ?    6 Yes 23 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are data pump export and import modes?

1110


What is tns name?

1026


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1951


What happens if you set the sga too low in oracle?

1223


Can multiple columns be used in group by in oracle?

1037


What is a data lock in oracle?

1180


How many anonymous blocks can be defined?

1251


How to create an oracle database manually?

1129


What is a dynamic performance view in oracle?

1057


How to sort the query output in oracle?

1073


What types of joins are used in writing subqueries?

1030


What is a nvl function?

1093


what happened to the global index when I truncate the data in one of the partition?

2066


How do I uninstall oracle 11g?

1176


What are the tools for Oracle ?

1107