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
- 24789 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kondeti srinivas
Select * from (select rownum as rn, emp.* from emp) where
rn in (1,3,5);
| Is This Answer Correct ? | 22 Yes | 0 No |
Answer / 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 |
display odd records
select * from emp where (rowid,1) in ( select
rowid,mod(rownum,2) from emp)
display even records
select * from emp where (rowid,0) in ( select
rowid,mod(rownum,2) from emp)
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / amedela chandra sekhar
Select * from (select rownum as rno, emp.* from emp) where
rno in (1,2,5);
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / amedela chandra sekhar
Select * from (select rownum as rno, emp.* from emp) where
rno in (1,3,5);
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gyana
SELECT RN,EMPNO,ENAME,SAL FROM
(SELECT ROWNUM RN,EMPNO,ENAME,SAL FROM EMP)
WHERE RN IN (1,3,5)
---------------------------------------------------
I ALREADY TESTED ITS WORKING..PLS ANY CORRECTION LET ME KNOW
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sp hari
select * from emp where rowid=(select
decode(mod(rownum,2),0,null,rowid) from emp)
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / kondeti srinivas
select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp where rownum<=5)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anjan
select rownum,empno,ename,sal from (select
rownum,empno,ename,sal from emp)
group by rownum,empno,ename,sal
having rownum in (1,3,5)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / uma
select * from (select rownum rn,ename,job,sal
from emp)
where mod(rn,2) <> 0;
| Is This Answer Correct ? | 2 Yes | 1 No |
What is an active transformation?
What is a look up function? What is default transformation for the look up function?
How we can create indexes after completing the load process?
wht is full process of Information source to target just like stg to productuon and development
What is meant by query override?
Define mapplet?
difference between stop and abort
How can you define user defied event?
What happens if the info. Server doesn't find the session parameter in the parameter file?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
where to store informatica rejected data?
Teradata 
