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
- 25400 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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How union transformation is used?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain pushdown optimization $pushdownconfig parameter - informatica
What's the layout of parameter file (what does a parameter file contain?)?
Define joiner transformation?
can anyone suggest best free Talend data integration training online
Explain the aggregator transformation?
Describe data concatenation?
Define enterprise data warehousing?
Explain direct and indirect flat file loading (source file type) - informatica
What is a stored procedure transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the different types of olap? Give an example?
