Advertisement
Guest User

Untitled

a guest
Apr 25th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. SELECT sum(c), count(c), sum(c) - count(c)
  2. FROM (
  3. SELECT count(*) as c
  4. FROM public."DistrictCriminalCase"
  5. GROUP BY fips, "CaseNumber"
  6. HAVING count(*) > 1) a
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement