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
- 25009 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
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to go to the older version for a mapping?
How can we update a record in the target table without using update strategy?
What are mapplets? How is it different from a Reusable Transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to handle decimal places while importing a flatfile into informatica?
Separate from a database, an information bazaar, and an information stockroom?
Differentiate between a repository server and a powerhouse?
How can we create index after completion of load process?
What is an Integration service in Informatica?
What is lookup change?
what is SDLC way of code development?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is data caches/ index caches?
