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
12 ноя 2022
