----- Original Message -----
> Hmph, so sybase hasn't thought through the implications of ORDER BY on
> a hidden column vs. DISTINCT either. Can anyone try it on some other
> DBMSes?
>
Using the following script...
create table t1(f1 int, f2 int); insert into t1(f1, f2) values(1,1); insert into t1(f1, f2) values(1,2);
insertinto t1(f1, f2) values(1,3); insert into t1(f1, f2) values(2,4); select distinct f1 from t1 order by f2;
Returned the following message under Oracle8 on NT: ORA-01791: not a SELECTed expression
Returned the following message under MS SQL Server 7.0: ORDER BY items must appear in the select list if SELECT
DISTINCTis
specified.
I could try it on Oracle8i but I suspect the result will be the same.