DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone >

Unique Values In Column

Snippets Manager user avatar by
Snippets Manager
·
Jan. 30, 07 · · Code Snippet
Like (0)
Save
Tweet
571 Views

Join the DZone community and get the full member experience.

Join For Free
//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.
Column (database)

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • How to Set Up and Run PostgreSQL Change Data Capture
  • Don't Underestimate Documentation
  • How to Handle Early Startup Technical Debt (Or Just Avoid it Entirely)
  • What Do Great Engineering Managers Need To Know About Compensation and Equity?

Comments

Partner Resources

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo