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

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Answer Posted / anjan

select rownum,empno,ename,sal from (select
rownum,empno,ename,sal from emp)
group by rownum,empno,ename,sal
having rownum in (1,3,5)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1028


Define joiner transformation?

986


What are the data movement modes in informatica?

1081


What if the source is a flat-file?

1042


What is rank transformation in informatica

1108


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1049


What is the function of look up transformation?

1054


How many ways are there to do 'remove duplicate records in informatica'?

954


What are the types of caches in lookup? Explain them.

917


What do you mean incremental aggregation?

1010


Do you find any difficulty while working with flat files as source and target?

1051


Explain the different kinds of facts.

934


What is meant by LDAP users?

1112


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1715


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1932