Subject | Re: Finding Unique Records with Union |
---|---|
Author | legrand_legrand_63 |
Post date | 2006-10-07T10:42:02Z |
oups ...
you are perfectly right
For derived tables, I have spécified in the initial message that it is
a FB 2.0 New Feature.
At last, Oracle doesn't support syntax:
select distinct A from
(select A,B from T)
order by B
and returns error ORA-01791 ... when FB doesn't beep.
Is that standard compliant ?
Regards
PAscal
you are perfectly right
For derived tables, I have spécified in the initial message that it is
a FB 2.0 New Feature.
At last, Oracle doesn't support syntax:
select distinct A from
(select A,B from T)
order by B
and returns error ORA-01791 ... when FB doesn't beep.
Is that standard compliant ?
Regards
PAscal