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

SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND
ROENUM=5

Is This Answer Correct ?    5 Yes 32 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does refresh system mean, and what are its distinctive choice?

1270


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1147


Define pmcmd command?

1103


How do you load first and last records into target table?

1209


What is an expression transformation in informatica?

1089


What is meant by lookup transformation? Explain the types of lookup transformation?

1019


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1986


How to generate sequence numbers without using the sequence generator transformation?

1254


Explain the informatica workflow?

1124


wat are deployement groups in informatica, how it will be used for developers

1770


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1164


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1306


What is meant by query override?

1112


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7370


How big was your fact table

1859