Avoid Duplicates in the Result of a SELECT Query in SQL
Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how.
How to Avoid Duplicate Results
- Simply use the DISTINCT clause and between the SELECT clause and the fields.
- Example:
SELECT distinct id,name,surname FROM mytable
- More informations available on this : Link
Photo: Unsplash
Related
- Sql avoid duplicates
- Avoid duplicates in sql - Best answers
- How to avoid duplicates in sql - Best answers
- How to duplicate a google doc - How-To - Google
- How to avoid unknown calls - How-To - Android
- Export diagram sql server - How-To - Programming
- How to stop itunes from duplicating songs - How-To - iTunes
- Pl sql reset sequence - How-To - Oracle
This document, titled « Avoid Duplicates in the Result of a SELECT Query in SQL », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
