SQL query for count

programmer_kay · April 17th, 2004, 05:04 PM

Hi,
   I have two tables as table1(featureid) and table2(featureid). The difference is table1 has duplicate records of feature ids like
Featureid
1
1
2
and table 2 has unique set of featureids
Feautreid
1
2

So, now I want something which counts how many entries of a particular featureid are there in table1. i.e.

featureid count
  1 2
  2 1

How can I do this.
Any help is appreciated. Thanks!!

melvik · April 18th, 2004, 02:48 AM

Code:

SELECT Count(Featureid)
FROM urTable
GROUP BY Featureid

Always:),
Hovik Melkomian.