Re: selecting the last 10 rows...

From: Neil Hulin <nospam_at_*NOSPAM*litech.freeserve.co.uk>
Date: Tue, 1 Dec 1998 20:14:55 -0000
Message-ID: <741ott$fl1$2@newsreader5.core.theplanet.net>

Why do you want to select the last ten rows (or the first ten rows for that matter)?

If this is a design requirement then there should be a better definition of how to identify the candidate rows. It sounds like fuzzy analysis to me - someone doesn't understand the problem or does understand the problem but couldn't define the correct solution. If you can come up with a correct definition and solution then your resulting SQL should be easily implemented and probably much more efficient than the solutions proposed here.

--
...neil {actually: neil [dot] hulin [at] litech [dot] freeserve [dot] co [dot] uk} Received on Tue Dec 01 1998 - 14:14:55 CST