What Is SQL Distinct and How Can You Use It?

[@omerkeidar95]

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!

[@DatabaseStar]

Thanks! Glad it was helpful for you!

[@twinkledeye2737]

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

[@DatabaseStar]

Thanks!

[@Dopamine_fighter]

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

[@DatabaseStar]

I think it would show similar results, but I don't know if it does something different behind the scenes.

[@COOKINGBIRD]

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

[@DatabaseStar]

Glad it was helpful!

[@MM-cl5ik]

Thank you very much, this is very helpful.

[@DatabaseStar]

Glad you like it!

[@oswaldovirto5896]

Thank you very much. Liked and subbed!

[@DatabaseStar]

No problem!

[@dn9416]

Hope you are doing well Benn..

[@DatabaseStar]

Thanks, I am

[@BSITVinluanEner]

Helpful video !

[@DatabaseStar]

Thanks!

[@samuelthomas1575]

Thank you for that helpful video.

[@DatabaseStar]

Glad it was helpful!

[@mycelium1213]

your voice is amazing holy shit

[@DatabaseStar]

Thanks a lot!

[@ayaaaa8298]

You are AMAZING

[@DatabaseStar]

Thanks!

[@mostafayasser5645]

Nice Video

[@DatabaseStar]

Thanks!

[@SanjayKumar-yh8fd]

Thanks sir, for the upload this

[@DatabaseStar]

No problem!

[@MohammedIbrahim-hk2bp]

This keyword distinct why must used in join ?!

[@DatabaseStar]

You don't have to use the DISTINCT keyword in a join, the join will work without it.

[@MohammedIbrahim-hk2bp]

@@DatabaseStar no it's cause me repeated in select data and actually database is just one row