Re: renumbering the data in a column?

From: gazzag <gareth_at_jamms.org>
Date: Thu, 15 Jan 2009 08:14:28 -0800 (PST)
Message-ID: <dc20bf76-9710-4159-9f18-fa86a27b152d_at_t26g2000prh.googlegroups.com>

On 14 Jan, 20:02, m..._at_pixar.com wrote:
> I have some rows that I would like to renumber. �For example:
>
> � � select * from t where name like 'x%' order by seq;
>
> � � seq � �name
> � � --- � �----
> � � �15 � �xfoo
> � � �17 � �xbar
> � � �26 � �xbaz
>
> desired state, seq column renumbered starting at 1:
>
> � � seq � �name
> � � --- � �----
> � � � 1 � �xfoo
> � � � 2 � �xbar
> � � � 3 � �xbaz
>
> Is there a single sql statement that can do this? �Or should I
> just loop over the result set and manually update the seq
> for each row?
>
> Many TIA!
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios

I'm with Mark D Powell on this: why do you need to renumber that column anyway?

-g Received on Thu Jan 15 2009 - 10:14:28 CST