|
|
Posted by petersprc on 11/16/07 02:42
Hi,
You could probably select rownum.
On Nov 15, 12:30 pm, "Steve" <no....@example.com> wrote:
> i know i know...just get over it. look at the date of the last post/response
> in an oracle ng. :)
>
> this is a mysql specific query. i want to do the same thing in oracle. i
> don't know how. the following gives a dynamic/unique id number to a set of
> selected records. it kind of mimics RANK() in oracle. it's based on a
> cartesian...anyway, if anyone can fill me in on a similar oracle translation
> to this mysql query, i'd just about break down and cry from joi.
>
> tia
>
> =============
>
> SELECT @id := @id + 1 Id ,
> Value
> FROM
> (
> SELECT @id := 0
> ) uniqueId ,
> (
> SELECT 'ABC' Value
> UNION
> SELECT 'DEF' Value
> UNION
> SELECT 'GHI' Value
> ) pseudoTable
Navigation:
[Reply to this message]
|