Re: Limitting result without ROWNUM

From: Gerard H. Pille <ghpille_at_hotmail.com>
Date: 22 Jan 2007 03:57:24 -0800
Message-ID: <1169467044.581840.59070@38g2000cwa.googlegroups.com>

Charles Hooper schreef:

>
> Nice solution - one that I had not considered. Above is the 11th
> solution provided to this problem.
>
> Dieter Noeth provided solution #12 (I had to change "t1 AS t2" to "t1
> t2" before it would execute)
>
> Method #13 (loosely inspired by the above SQL statement):

> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

Come on Charles, don't keep us waiting: trace them and let us know which one provides the best performance. Adding in index on size would probably help mine. Received on Mon Jan 22 2007 - 05:57:24 CST