[thelist] SQL Query : using Group By and Order By together

rudy r937 at interlog.com
Fri Jan 4 20:05:36 CST 2002

> I am afraid you've mistaken my goal, it is not to have several times the
> same logo, but to GROUP all entries featuring the aplogo into ONE row.


you mean, instead of

   aplogoA   date1
   aplogoA   date2
   aplogoA   date3
   aplogoB   date7
   aplogoB   date8

you want

   aplogoA   date1  date2  date3
   aplogoB   date7  date 8

that's very very hard to with sql

you need to use the query i gave you (without GROUP BY) and "flatten" the
results (that's a technical term) using php

> ps: you said: "what GROUP BY does is create one row for each
> value of the group" do you mean, as I think _group by_ behaves, it
> creates one row including all values of the group ?

no, it creates one row for each group and some *aggregate* information
about the group

using the example data above,

    select aplogo, count(*)
      from table
       group by aplogo


    aplogoA  3
    aplogoB  2

another example,

   select aplogo, max(apdate)
      from table
       group by aplogo


   aplogoA  date3
   aplogoB  date8

see?  one row per group


More information about the thelist mailing list