Parimala

• Sep 5th, 2006

 

(select * from emp
minus
select * from emp where rownum < 70)
intersect
select * from emp where rownum <=70

csr21

 Profile Answers by csr21 Questions by csr21

• Sep 8th, 2006

 

select * from emp where rownum<=70
minus
select * from emp where rownum<70;

Ram Pratap Singh

• Sep 9th, 2006

 

select * from ( select rownum rnum, a.* from emp)

where rnum = 70

krishna

• Sep 26th, 2006

 

select * from emp where rownum<71

minus

select * from emp where rownum<70;

jimmy514in

 Profile Answers by jimmy514in Questions by jimmy514in

• Jul 2nd, 2010

 

Why cannot we use select * from table_name where rownum=70??