how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
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
How will the document be delivered to me?
What is status code in informatica?
pmscmd startworkflow -sv
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain the pipeline partition with real time example?
What is the procedure for creating independent data marts from informatica 7.1?
What is a sequence generator transformation?
To import the flat file definition into the designer where should the flat file be placed?
What is Index Caches size?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Explain the types of lookup transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what is mean by complex business rule ?
What are the components of the workflow manager?