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 / gopi k

rownum is pseudo column, when query extracts rows rownum
will be appended to query. So where rownum = 3 condition is
a wrong one.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the Default Source Option For Update Strategy Transformation?

1242


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2726


Explain transaction control transformation in informatica

1272


What is the surrogate key?

1268


r u done any partitions in ur project?

1827


What does role playing dimension mean?

1048


How can we create index after completion of load process?

1126


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1269


What are the databases that informatica can connect to windows?

1056


What is a stored procedure transformation?

1056


How can we use batches?

1026


How can we improve session performance in aggregator transformation?

1118


What is the Process to creating lookup transformation in informatica

1046


Name the different lookup cache(s)?

1236


Explain how to import oracle sequence into informatica?

1020