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
- 25875 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / suresh
TO DISPLAY THE EVEN NUMBERS
SELECT ROWNUM,EMPNO,ENAME,SAL FROM EMP
GROUP BY ROWNUM,EMPNO,ENAME,SAL
HAVING MOD(ROWNUM,2)=0;
TO DISPLAY THE ODD NUMBER IS TO REPLACE ONLY MOD(ROWNUM,2)!=0
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How to load a Dimension ? and how to load a fact table?
What are the differences between joiner transformation and source qualifier transformation?
Explain incremental aggregation in informatica
expain about the tune parameters?
What is decode in static cache?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are different types of transformations available in informatica?
What is meant by a domain?
Explain in detail scd type 2 through mapping.
Define the various join types of joiner transformation?
What is dimensional table?
what is mean by complex business rule ?
what is the -ve test case in your project.
Where can we find the throughput option in informatica?
How many ways are there to create ports?
