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
- 25905 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 DSS?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
How can u stop a batch?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
How to load the source table into flat file target(with columns) in informatica?
What are the types of lookup?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
what is the size of your data warehousing?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
State the differences between sql override and lookup override?
need for registering a repository server
Teradata 
