What Is SQL Distinct and How Can You Use It?

Опубликовано: 29 Сентябрь 2024
на канале: Database Star
20,980
382

📝 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)