A complex SQL query

[John Varghese]

Hi,
  How to write this using torque

SQL>  select ROWNUM , vendor_code from (select * from lot_set order by vendor_code) 
where          
                ROWNUM <20
  2   minus
  3   select ROWNUM , vendor_code from (select * from lot_set order by vendor_code) 
where  
                ROWNUM <10;

    ROWNUM     VENDOR_COD
----------     ----------
        10     0000004127
        11     padmin
        12     padmin
        13     padmin
        14     padmin
        15     padmin
        16     padmin
        17     padmin
        18     padmin
        19     padmin


Pls help
Bye
John