What Is SQL Distinct and How Can You Use It?

preview_player
Показать описание

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)
  1. Database Star
  2. oracle
  3. sql
  4. programming
  5. dbsoraclefunction
  6. database
Рекомендации по теме
What Is SQL 0:06:35

What Is SQL Distinct and How Can You Use It?

Using DISTINCT in 0:08:53

Using DISTINCT in SQL

COUNT, DISTINCT, and 0:03:25

COUNT, DISTINCT, and NULLs in SQL Server

SQL Distinct and 0:02:52

SQL Distinct and Multiple Columns

SQL Tutorial deutsch 0:05:16

SQL Tutorial deutsch - SELECT DISTINCT

SQL distinct vs 0:01:12

SQL distinct vs group by

Abfragen in SQL 0:04:14

Abfragen in SQL mit SELECT - Teil 5 (COUNT und DISTINCT)

SQL SELECT DISTINCT 0:01:46

SQL SELECT DISTINCT statement (return different values) | SQL Tutorial for Beginners | 2021

Paradise Islands: Mastering 0:27:10

Paradise Islands: Mastering SQL to remodel event, customer and user session data to your will

SQL - Part 0:06:44

SQL - Part 4 - distinct keyword

T-SQL - DISTINCT 0:02:46

T-SQL - DISTINCT Keyword

How to get 0:00:27

How to get COUNT of DISTINCT VALUES in SQL

SQL Tutorial - 0:02:31

SQL Tutorial - 27: The DISTINCT Keyword

23 - | 0:06:34

23 - | MS SQL Server For Beginners | - | Select Statement - Distinct keyword| - | Part 4 |

SQL de A 0:06:23

SQL de A à Z - Fondamentaux de SQL 02 - SELECT DISTINCT #06

DISTINCT in SQL 0:05:56

DISTINCT in SQL || Lesson 70 || DBMS || Learning Monkey ||

Distinct | Order 0:07:05

Distinct | Order By in SQL | SQL in Tamil | Logic First Tamil

36. SELECT DISTINCT 0:09:03

36. SELECT DISTINCT SQL Command

MS SQL tutorial 0:08:03

MS SQL tutorial on the use of Distinct, TOP and Order By

SQL in Telugu 0:04:36

SQL in Telugu - What Is SQL Distinct and How Can You Use It?

Advanced Aggregate Functions 0:06:00

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

DISTINCT Clause in 0:09:00

DISTINCT Clause in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar

SQL | Find 0:10:54

SQL | Find UNIQUE and DISTINCT values in SQL|Eliminate duplicate records from table|UNIQUEvsDISTINCT

What is the 0:04:48

What is the difference between 'Group by' and 'Distinct' in SQL?

Комментарии
Автор

Came here after an online course did a less than stellar job on this topic (Udacity, great otherwise imo). And this was the most detailed explanation I've found yet. Thank you!

omerkeidar
Автор

Sending a huge thank you for the comprehensive SQL tutorial. It's incredibly helpful! 😄🎥💻🔍

COOKINGBIRD
Автор

Thank you very much, this is very helpful.

MM-clik
Автор

Straight to the point, easy to understand and really helpful! Thanks!

twinkledeye
Автор

Does it works the same way as group by without any aggregate funcs?

where_is_the_manager
Автор

How to select 5 name using distinct? Sir

Champa-sama
Автор

This keyword distinct why must used in join ?!

MohammedIbrahim-hkbp
Автор

Thank you very much. Liked and subbed!

oswaldovirto