Re: "un-grouping" results

"Alan" <alan_at_erols.com> a écrit dans le message de news:36s6grF56fqudU1_at_individual.net...
|
| <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?

I think the question behind the "expected" is "why does it return one row?"

Regards
Michel Cadot Received on Tue Feb 08 2005 - 14:41:59 CST