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>


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

Original text of this message