Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: query to delete last record of a table

Re: query to delete last record of a table

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Mon, 18 Apr 2005 10:58:11 +0000 (UTC)
Message-ID: <d403s3$b52$1@klatschtante.init7.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US