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

In a table, 4 person having same salary. How to get Third
person record only?

Answer Posted / mr.lee

id sal

101 1000

102 1000

103 1000

104 1000

Select Rn, id, Sal, From (
Select Rownum Rn, id ,Sal From Emp)
Where Rn = 3

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Different circumstance which drives informatica server to expel records?

983


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

1043


What is a mapplet/worklet in informatica?

1188


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1322


Explain the tuning lookup transformation - informatica

995


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186


How you prepared reports for OLAP?

1597


What is standalone command task?

1316


Define mapplet?

1009


How many ways a relational source definition can be updated and what are they?

1017


Which is the t/r that builts only single cache memory?

1190


What is meant by LDAP users?

1209


How big was your fact table

1803


What is informatica etl tool?

1000