DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Unique Values In Column

  • submit to reddit
        //Find out if a value is unique in a column.

select count(debiteurennummer) as aantal, debiteurennummer from vestiging group by debiteurennummer order by aantal desc

Replace debiteurennummer by naam... hoe vaak is mijn relatienaam uniek?

en natuurlijk ook personeelsnummer in persoon.