Re: "un-grouping" results

<mikharakiri_nospaum_at_yahoo.com> wrote in message news:1107814458.481706.31150_at_c13g2000cwb.googlegroups.com...
> Just discovered today. How many rows
>
> select dummy, prior dummy
> from dual
> connect by dummy > prior dummy
> and prior dummy is not null
> and prior dummy is null
> and prior dummy = 'a'
> and prior dummy <> 'a'
>
> is expected to return?
>

One row. Why do you ask instead of just running it? Received on Tue Feb 08 2005 - 10:08:57 CST