Re: [sqlite] Implementing type find on a large result set

[Steve Krulewitz]

Thanks, Samuel, I forgot that trick :)

cheers,
-steve

On 4/6/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote:

Instead of using LIKE use '<' to get a count of records before the one your
targeting.  Something like this would work (names are from my schema):

SELECT PermissionRef
FROM LU_Permissions
LIMIT 10
OFFSET (
        SELECT COUNT(*)
        FROM LU_Permissions
        WHERE PermissionRef < 'Sc');

HTH,

Sam



-------------------------------------------
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------