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
- 25450 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
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How we can create indexes after completing the load process?
What is complex mapping?
What is the fact table?
how many types of dimensions are available in informatica?
Define the various join types of joiner transformation?
What does reusable transformation mean?
Is it possible to use a client with different version than that of its Informatica server?
What is workflow manager?
Can anyone tell me the new features in Informatica 9 Version?
Explain the use of aggregator cache file?
What are the new features of informatica 9.x at the developer level?
Explain scd type 3 through mapping.
What are the advantages of using informatica as an etl tool over teradata?
How many ways are there to do 'remove duplicate records in informatica'?
