Re: subquery bug ?

[Mike ART]

Hi Peter,
I understand "Group By is specified to return arbitrary values for columns that neither aggregate nor Group By", but in my opinion, it does not explain the differential results between method 1 and method 2.

I think I've got stuck here somehow, and can't get it through. Can you please tell me if method 1 is identical to method 2 (in terms of results) ? if not, why ?


Method 1

>create table test2 as (select * from test order by id, type DESC);
> select * from test2 group by id;

Method 2

> select * from (select * from test order by id,type desc) as t group by id;



Thank you very much.