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

select * from (select salary.*,rownum r from salary where
sal=(select sal from salary group by sal having count(sal)
=4)) where r=3

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the guidelines to be followed while using union transformation?

1065


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1926


What is sorter transformation?

976


Enlist the advantages of informatica.

1005


Can we change Dynamic to Static or Persistent cache? If so what happens?

2147


What are the differences between oltp and olap?

921


What do you mean incremental aggregation?

1010


How will the document be delivered to me?

1018


Can we create multiple integration service on single repository?

1132


Is stop and abort are same in informatica?

947


How to join three sources using joiner? Explain though mapping flow.

1090


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

991


What are mapplets?

1211


What are the different ways to implement parallel processing in informatica?

1340


How do you use reject loader.

2543