Re: Simple Question!

Anthony B. Cillo (tmaxwell_at_crl.com) wrote:
: I am trying to find the oldest 1000 patients in our database. The
: problem is that I cannot get the system to stop after returning 1000
: rows. I have tried using rownum but that only works if you are not
: using order by.
 

: Any ideas?
 

: Thanks
 

: Tony

Why not sort the patients in descending order by date where rownum <= 1000? That way you will get the information you are looking for in the order you are looking for.....

--
---
Ken Niedermeyer			| The views expressed above do not represent
Computing Systems Analyst	| those of my employer.... (but when do they?)
Boeing Computer Services (BCS)  | 
                                | NOTICE:
Internet:                       | Lack of planning on your part
kan9691_at_eeidf002.ca.boeing.com  | does not constitute an emergency on my part.