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
- 25243 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 are the uses of etl tools?
Where is metadata stored?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is a mapplet/worklet in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain what is informatica metadata and where is it stored?
Explain in detail about scd type 1 through mapping.
What are the differences between oltp and olap?
What the difference is between a database, a data warehouse and a data mart?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What do you mean by channel change?
What are the types of caches in lookup?
What is meant by a domain?
What do you understand by a term domain?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
