Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Retrive values from different rows
sviluppo.sw_at_gmail.com wrote in news:1182090432.657924.152450
@m36g2000hse.googlegroups.com:
> Hi,
> I've this intriguing problem.
>
>>From a table like this>
> ID ART QTA REASON
> 1 A 10 W
> 2 A -2 C
> 3 A 3 PO
> 4 A -4 C
> 5 B 5 W
> 6 B -2 C
> 7 B -4 C
> 8 B 5 PO
> 9 C 5 W
> 10 D 7 W
> 11 ... ... ...
> 12 ... ... ...
You have a fundamental misconception!
SQL returns a set (collection) of rows which have NO fixed order;
[unless & until the ORDER BY clause is part of the query].
Therefore there is no such thing as N-1 row.
HTH & YMMV Received on Sun Jun 17 2007 - 09:51:43 CDT