📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
The DISTINCT keyword in SQL allows you to eliminate duplicate records from the results of your SELECT query. This video explains how to use SQL DISTINCT, how to use it with COUNT, and one thing to be aware of.
The demonstration uses MySQL, but the code and concept work in many other vendors (Oracle, SQL Server, PostgreSQL, MySQL)