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
- 24753 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
Write the prerequisite tasks to achieve the session partition?
What are the different types of repositories created using informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Enterprise data warehouse your projects phase by phase explain?
What are the different types of olap? Give an example?
How do you convert single row from source into three rows into target?
What is meant by query override?
How to join three sources using joiner?
How you can differentiate between connected lookup and unconnected lookup?
What are the measure objects?
what is SDLC way of code development?
Do you find any difficulty while working with flat files as source and target?
How we can create indexes after completing the load process?
what is the size of u r source(like file or table)?
