Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: selecting the last 10 rows...
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
![]() |
![]() |