Re: Many aggregates in one query

In article <9lk0u0$g70$1_at_stlnews.stl.ibm.com>, Aakash Bordia says...
>
>How about
>SELECT col1,COUNT(*) FROM IN1 group by col1 order by count(*),col1 fetch
>first 1 rows only

Right. Except that "fetch first 1 rows only" can be transformed into something more legitimate like

select * from( select *, rownum rn from inner_query) where rn < 2

The query becomes:

select minnum, rowcnt from (
select minnum, rowcnt, rownum rn from ( select id, count(1) rowcnt from test group by id order by rowcnt, id )
) where rn < 2 Received on Sat Aug 18 2001 - 01:58:43 CEST