SQL query for count
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!!
|