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 / brajesh kumar

SELECT *FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP)

Is This Answer Correct ?    5 Yes 25 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a cursor variable?

1216


How to get the Installed Oracle Version Information ?

1191


Explain the use of online redo log files in oracle.

1081


What are the benefits of ordbms?

1139


what is the dual table in oracle?

1041


How to test null values?

1156


Why cursor variables are easier to use than cursors?

1141


What is a trace file and how is it created in oracle?

1147


Write a syntax for update query in oracle?

1076


How does oracle handle read consistency?

1153


What is the fastest query method to fetch data from the table?

1418


What is oracle and what are its different editions?

1121


How to export your connection information to a file?

1177


Explain the use of grant option in imp command.

1083


What is a connect identifier?

1086