PHP

sql where count greater than

SELECT id, COUNT(id)
FROM User
GROUP BY id
HAVING COUNT(id) > 1

sql count value greater than

SELECT COUNT(1) AS NumberOfGreaterThan0 
FROM YourTable
WHERE col1 >=0