Sub select..

Hi,

I would like to know if ther is a way of doing something like this :

select max(col1) from (select count(*) as col1 from table1 where index_field
= 3 group by day);

table1 loking like :

day    |   index_field   | ...
-------------------------------------
1                1
1                1
1                3
1                3
2                3
3                1
3                3



Finally, I only want to know the maximum count(*) value grouped by day

my sub query should return me :

col1
-------
2      (for day 1)
1       (for day 2)
1       (for day 3)

So, Max(col1) would return me " 2 "

but... imbriqued select doesn't seems to work in 6.5.3....

Any suggestions?

/fb