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

We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,

like select col1,col2,rownum
from tab1
where rownum=3

Is This Answer Correct ?    1 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is session task and command task?

1182


What are the designer tools for creating transformations?

1050


What all are steps in up gradation of Informatica server?

992


What is the need of etl tools?

1053


What is decode in informatica?

1074


Describe the impact of several join conditions and join order in a joiner transformation?

1010


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1138


How do you promote a non-reusable transformation to reusable transformation?

1071


In development project what is the process to follow for an etl developer from day1

1653


What is dimensional table?

1004


can u give example for factless fact table

6447


Explain how to import oracle sequence into informatica?

953


Which are the different editions of informatica powercenter that are available?

972


Explain the pipeline partition with real time example?

1085


what is degenerated dimension?

3873