db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Varghese" <john.vargh...@kalzoom.com>
Subject A complex SQL query
Date Sat, 31 Jan 2004 13:36:10 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message