Unique vs distinct sql

Sql distinct vs unique

Unique: helps to ensure that all the values
in a column are different
Distinct: helps to remove all the duplicate
records when retrieving the records from a table.

Source: grepper.com

Similar codes

1 vote282 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote280 views1 answer
Python mysql executemany
SQL
10 votes315 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote292 views1 answer
How to tell if i have lactose intolerance
SQL
47 votes350 views6 answers
Add column mysql
SQL
0 vote276 views1 answer
Show all mongodb
SQL
1 vote289 views1 answer
How to update date add hours in postgresql
SQL
0 vote570 views1 answer
How to connect .sql data set to powerbi
SQL
6 votes301 views2 answers
Psql load dump
SQL
11 votes300 views5 answers
Sql server reset identity
SQL