SQL query for count
I have two tables as table1(featureid) and table2(featureid). The difference is table1 has duplicate records of feature ids like
and table 2 has unique set of featureids
So, now I want something which counts how many entries of a particular featureid are there in table1. i.e.
How can I do this.
Any help is appreciated. Thanks!!