From: rdm32@dana.ucc.nau.edu (Ryan McLean) Newsgroups: comp.databases.oracle Subject: Re: Should be a simple query, please help a desperate person at the end of their pitiful rope. Date: 6 Jun 2003 00:03:39 -0700 Organization: http://groups.google.com/ Lines: 10 Message-ID: References: NNTP-Posting-Host: 134.114.12.42 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1054883019 2863 127.0.0.1 (6 Jun 2003 07:03:39 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 6 Jun 2003 07:03:39 GMT Thanks for your help Jim, I really appreciate it! I have one question, this query is dynamic, so there may be like 4 of 6 records I need to retrieve. So would need to query for the most recent 4 records of 6. Could I use a sub query somehow (it is really late where I am). I'll have to look at this again in the morning :] Thanks again! Ryan