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 / biswa

select distinct(e1.sal) from emp e1 where &n=(select count(distinct(e2.sal)) from emp e2 where e1.sal <=e2.sal)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is expression transformation?

1037


What is the reusable transformation?

1008


wf dont have integration severances how you can run?

1887


Explain the types of transformations?

1007


lookup transformation with screenshots

3941


can anyone suggest best free Talend data integration training online

1623


How to improve the performance of a session using sorter transformation?

1095


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1730


What is a router transformation?

1050


Differentiate between Load Manager and DTM?

2096


Can anyone tell me the new features in Informatica 9 Version?

2033


Explain the shared cache and re-cache?

1051


What is an unconnected transformation?

1035


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9980


What are the new features of informatica 9.x at the developer level?

987