Harsa

• Apr 19th, 2006

 

select empno, ename from emp where rownum <=&upto

minus

select empno, ename from emp where rownum <=&start;

 

manish

• Apr 3rd, 2007

 

select * from client_master where client_id between '2001' and '2006'

LRANI

 Profile Answers by LRANI 

• Jul 31st, 2007

 

Hi,
minus is used for finding the missing records between 2 tables and not finding the records between the range.

It is BETWEEN operator that displays the records between 2 ranges from single table.

patilpravin_1981

 Profile Answers by patilpravin_1981 

• Jan 30th, 2008

 

select * from employees where salary between(1000 and 5000);