neilheuer
SSC Eights!
Points: 946
More actions
June 20, 2002 at 10:38 am
#105491
I Would like to get a bunch of counts from a single query.
I Want the number of rows with ID =1 numberof ROws with ID = 2 and so on all from the same table. Anyone know how I can do that.
Neil
Steve Jones - SSC Editor
SSC Guru
Points: 736255
June 20, 2002 at 10:40 am
#431282
use GROUP BY and the ID fields
select count(*), id
from tableA
group by id
Steve Jones
steve@dkranch.net
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply