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
- 16 Answers
- 24745 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / siva reddy
display odd records
select * from emp where (rowid,1) in ( select
rowid,mod(rownum,2) from emp)
display even records
select * from emp where (rowid,0) in ( select
rowid,mod(rownum,2) from emp)
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
What is status code in informatica?
I have a flat file, want to reverse the contents of the flat file
If informatica has its scheduler why using third party scheduler?
What is the function of look up transformation?
What is session task and command task?
Which transformation should we use to normalise the COBOL and relational sources?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is mean by complex business rule ?
lookup transformation with screenshots
Difference between Data and Index Caches?
Explain the aggregator transformation?
explain abt ur project architecture?
What are the types of schemas we have in data warehouse.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Whats the difference between informatica powercenter server, repositoryserver and repository?
