Re: [Beginner] Problem with Order by of a date

> -- This is better because in the inner select, it
> -- orders a descending and assigns a value to r.
> -- This value starts with 1 and is incremented by
> -- 1 for each row.
> -- The outer select then selects the (desired) row
> -- whose r = 1.

Reading my own post, I realize that I have chosen two bad column names in the sample script. The sentence above should read:

  This is better because in the inner select, it   orders THE COLUMN a descending and assigns a value to r.

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/