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

Write the unconnected lookup syntax?

1029


What is the use of transformation?

945


Write the prerequisite tasks to achieve the session partition?

1071


how to create user defined function (udf) in informatica

1243


Explain your project of banking domian.

1605


what is the -ve test case in your project.

2329


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1991


How can a transformation be made reusable?

1077


What do you understand by a term domain?

1061


How can we use batches?

961


What is meant by pre and post session shell command?

1104


Where are the source flat files kept before running the session?

1010


How to load last n records of file into target table - informatica

1018


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2077


what is unit testing?tell me proceedure

2164