Help adding in a query

P

pokdbz

I have a query Multipule in that query there are fields IdNumber and Multipule.
I need to make a query that counts how many Multipule is >=2 how do I do this.
 
P

Pieter Wijnen

Per id Number:

SELECT IDNUMBER, COUNT(*) FROM MULTIPULE
WHERE MULTIPULE >=2
GROUP BY IDNUMBER

Overall:
SELECT COUNT(*) FROM MULTIPULE
WHERE MULTIPULE >=2
 
Top