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

In this video we see how to find unique and distinct values in sql.
Distinct means, different values regardless how many times it appears in the dataset. DISTINCT keyword in SQL .
Syntax : Using SELECT immediately followed by the DISTINCT keyword. All the duplicate rows are removed from the result set.
Unique value is the value that only appears one time.
UNIQUE keyword in SQL (constraints) - ensure that all values in the column are different. Here we are not using UNIQUE constraints because constraints are normally used when creating a table. Here we find unique values from the table using a different method.
"Thanks for watching. If you liked this video, make sure to subscribe for more!”
#dataprojecthub
#data_project_hub

[@aal2002]

Thank you very much!

[@KiranKumar-le7sq]

keep posting interview related scenarios in detailed manner

[@dataprojecthub]

Hi Kiran, started with this query. Will be posting more.
th-cam.com/video/EbeudkX1Ntc/w-d-xo.html

[@victorprasan1893]

hi, great video,, keep up the good work.

[@dataprojecthub]

Hi Victor, Thanks

[@KiranKumar-le7sq]

nice video dude

[@dataprojecthub]

Thanks!

[@धिरजसुर्यवंशी]

Thanks

[@dataprojecthub]

Welcome😀