Help with SQL statement ( Query)

[fluffyvampirekitten]

Help me check if my sql statement is wrong

SELECT GROUPING.INSTITUTION, Count(GROUPING.GROUP_NO) AS NO_OF_GROUP
FROM (SELECT GROUP_NO,CATEGORY, FIELDMATCHED,  INSTITUTION
FROM CrossSystemData) AS GROUPING
WHERE ((GROUPING.CATEGORY)="POTENTIAL DUP");

[Mahendra1000]

What error is it getting?

[fluffyvampirekitten]

What error is it getting?

This is the erro that I'm getting
Your query does not include the specified expression "INSTITUTION" as part of an aggregate function

[RayMilhon]

Since your using the Count Function you also have to include a Group By Grouping.Institution after the where clause

[fluffyvampirekitten]

Since your using the Count Function you also have to include a Group By Grouping.Institution after the where clause

It works! May i ask why i need to include it the Group By .....?
So that I wont make the same mistake in the future.
By the way , Thank you so much

[RayMilhon]

Because the count is an aggregate function so all fields in the query must be aggregated so if you're not counting, summing or aaggregating the data you must group the data