Over a million developers have joined DZone.

Unique Values In Column

·
//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.
Topics:

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}