Mark Papadakis writes:
> Hi all,
>
> I was wondering what's wrong with a query like this:
>
> select itemlist , sum(field1), count(*) as cnt from table where where conditions
>group by id having cnt=2 order by field_x, field_y desc limit 10
>
> I am expecting to get the requested r
>Hi all,
>
>I was wondering what's wrong with a query like this:
>
>select itemlist , sum(field1), count(*) as cnt from table where
>where conditions group by id having cnt=2 order by field_x, field_y
>desc limit 10
>
>I am expecting to get the requested rows order by field_x. Those
>with s
Hi all,
I was wondering what's wrong with a query like this:
select itemlist , sum(field1), count(*) as cnt from table where where conditions
group by id having cnt=2 order by field_x, field_y desc limit 10
I am expecting to get the requested rows order by field_x. Those with same value (
