Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: query to delete last record of a table
On 2005-04-18, cricketunes_at_yahoo.com <cricketunes_at_yahoo.com> wrote:
> How can i find the highest value when the available values are C1, C2,
> C3....C10?
order by to_number(substr(COLUMN,2))
hth
Rene
-- Rene Nyffenegger http://www.adp-gmbh.ch/Received on Mon Apr 18 2005 - 05:58:11 CDT