Using DISTINCT in SQL

Published: 10 October 2018
on channel: Database by Doug
39,247
316

A brief beginner's introduction to the DISTINCT operator in SQL. DISTINCT creates a set of unique records, based on field values. In other words, duplicates records, based on field values, are removed. DISTINCT is often used with COUNT, to achieve a count of distinct values. Be aware that NULL is treated as a distinct value in terms of records, but COUNT ignores NULLs.
See the full code here: https://douglaskline.blogspot.com/201...


Watch video Using DISTINCT in SQL online without registration, duration hours minute second in high quality. This video was added by user Database by Doug 10 October 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 39,247 once and liked it 316 people.