SQL query for count

programmer_kay · #1 (**permalink**) 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 · #2 (**permalink**) April 18th, 2004, 02:48 AM

Code:

SELECT Count(Featureid)
FROM urTable
GROUP BY Featureid

Always:),
Hovik Melkomian.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
new display count query	carswelljr	SQL Language	9	May 7th, 2007 04:59 PM
SQL count query not giving correct results	hman	SQL Language	2	March 16th, 2005 07:06 AM
SQL count query not giving correct results	hman	SQL Server 2000	1	March 15th, 2005 01:15 PM
query count?	Raif	Access	1	June 18th, 2004 05:08 PM
SQL query for count	programmer_kay	SQL Language	1	April 17th, 2004 07:30 PM