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

What is the query to find nth highest salary?
What is the use of cursors?

Answer Posted / sbvp

select * from table name where sal in ( select * from
(select distinct sal from tablename order by sal desc)
where rownum<=&n);


if there is any another query plz tell me r mail me

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design time, run time. If you don't create parameter what will happen

1814


Differentiate between sessions and batches?

976


What are the components of the workflow manager?

1095


What is a transaction control transformation?

1158


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4692


What are the different ways to implement parallel processing in informatica?

1362


In informatica workflow manager, how many repositories can be created?

1297


Plz can any one say me how to get the informatica certification materials and dumps

2015


What are the different clients of powercenter?

1021


What does reusable transformation mean?

1088


Explain sessions and how many types of sessions are there?

971


What is Session and Batches?

1058


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1578


Mention few advantages of router transformation over filter transformation.

995


What is transformation?

1064