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