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

We can use Rank Trx, Select "salary" as Group by port and select "Date" or "Emp_id" as Rank Port and then Filter out records with Rank=3 thru Filter Trx.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is song in infrmatica...?

2242


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2556


How many numbers of sessions can one group in batches?

1066


Is it possible to create multiple domains on a single Informatica server?

1250


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2044


Tell me about Propagate functions in informatica

929


What are session parameters ? How do you set them?

1857


What are data-driven sessions?

1222


What are the advantages of using informatica as an etl tool over teradata?

1029


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

1207


What is a difference between complete, stop and abort?

1094


What are mapplets?

1282


Design a mapping to load a target table with the following values from the above source?

1355


Why update strategy and union transformations are active?

1051


What is native users?

1174