Sql query (having) (1 Viewer)

[Joy83]

Hi
How to add one more condition to the following query
I want to say where name=‘abc’


SELECT Name, COUNT(ID) AS Duplicate
FROM Products
GROUP BY Name,ID
HAVING COUNT(ID)>1

 

[theDBguy]

SELECT Name, COUNT(ID) AS Duplicate
FROM Products
WHERE [NAME]='ABC'
GROUP BY Name,ID
HAVING COUNT(ID)>1

 

[Joy83]

Thanks

 

[theDBguy]

Thanks

Hope it works...