> I'd be very interested to know how you can write an aggregate query
> without the group by clause.
>

What is the problem with this:

select min(B),max(B),count(*)
from myTable
where A=10

Why you are fetching all A's? to be sure about to they are exactly 10?

Ali