hi all,
i have table with 2 column :
account int
date datetime
i need to count avery time account is apper in this way -- meand add column name counter if needed
account date counter
aaaa 2009 1
aaaa 2010 2
aaaa 2011 3
bbbb 2009 1
bbbb 2010 2
thank alot sharon