Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT sum(c), count(c), sum(c) - count(c)
- FROM (
- SELECT count(*) as c
- FROM public."DistrictCriminalCase"
- GROUP BY fips, "CaseNumber"
- HAVING count(*) > 1) a
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement