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...

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Answer Posted / mahaboob

I would say that Raj has given the correct answer in general.

In most cases the interviewer restricts the parameter to be
written in the query as it might effect the performance.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is query image?

924


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2219


Is there any function in oracle similar like group_concat of mysql?

989


How to create a temporary table in oracle?

1194


Explain the use of rows option in exp command.

1023


What is the usage of merge statement?

1097


When system tablespace is created?

972


What are transaction isolation levels supported by oracle?

996


What is a static data dictionary in oracle?

1025


Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2902


How to use fetch statement in a loop?

973


How is it different from a normal table?

968


What is an oracle and why it is used?

1080


What is SQL access advisor in Oracle?

1137


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1846