Need help with a query

From: Ryan Gaffuri <rkg100_at_erols.com>
Date: 3 Apr 2002 12:24:36 -0800
Message-ID: <6757365f.0204031224.14871084@posting.google.com>

I have 3 columns that are important.

Primary_key
VARCHAR1
VARCHAR2 This is for a master-detail form.
The form is ordered by varchar1, varchar2

I need to to select the last record. I cannot use the built in last record. Long story. Its causing problems. So I need to do the query myself.

I am on forms 6i and Oracle 8i. I tried doing an order by in the where clause(that I thought I was supposed to be able to do in 8i?) in sqlplus and it did not recognize it.

Also varchar2 can be null so this killed some subqueries I had going. The primary_key is based on a sequence.

Thanks Received on Wed Apr 03 2002 - 14:24:36 CST