SQL - How to get distinct record based on a column

How do I write a SQL statement to pick up the distinct record based on ClientID
For example, this is my dataset,
ClientID code
1227 5200
1234 5500
1235 5100
1235 5600
1235 5700
1236 5500
1237 5200
1238 5500

I would like to get the result
1227 5200
1234 5500
1235 5100
1236 5500
1237 5200
1238 5500

Featured Post

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…

In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …

How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…