need newest date also

• pmcgillan

  Newbie

  Points: 5

  More actions

  November 23, 2004 at 6:26 am

  #87067

  Hi, I used this to pull out a count of number of times an item is in a table along with the items name. Now they want the date of the most recent entry, but it alludes me how to incorprate that into my existing statement. If nothing else, I could use output from this to requery for just the date, but that seems awfully wasteful.

  Select Count(*) as Icnt,Item From Log Group By Item Order By Item

  Any other thoughts?

  Thanks,

  Patrick

• SqlNightOwl

  SSCrazy

  Points: 2333

  More actions

  November 23, 2004 at 8:17 am

  #531228

  You might try

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

  --Paul Hunter