need newest date also

  • You might try

    select count(1) icnt, item, max(datecolumn) from Log group by item order by item

    --Paul Hunter

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply