Re: cold fusion drivers for oracle 8i
From: ACJohnst0n <acjohnst0n_at_aol.com>
Date: 11 Oct 2000 19:59:18 GMT
Message-ID: <20001011155918.09621.00001423_at_ng-cb1.aol.com>
Date: 11 Oct 2000 19:59:18 GMT
Message-ID: <20001011155918.09621.00001423_at_ng-cb1.aol.com>
To get the top 3 priced rows, how about using:
select * from products p1
where 3 > ( select count(*) from products p2
where p2.price > p1.price );
Received on Wed Oct 11 2000 - 21:59:18 CEST