Re: Simple Question!

From: Madhavi Lokam <gmadhavi_at_pms991.pms.ford.com>
Date: 1995/04/26
Message-ID: <3nm2j7$41p_at_eccdb1.pms.ford.com>#1/1


|> tmaxwell_at_crl.com (Anthony B. Cillo) writes:
|>
|> >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?

select [list of columns], ROWNUM from table_name where ROWNUM <=1000 ... Other conditions.... ORDER BY [list of columns];

This should work

Madhavi Lokam Received on Wed Apr 26 1995 - 00:00:00 CEST

Original text of this message