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.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.difference between unique vs primary key in sql
What is the difference between UNIQUE and PRIMARY KEY constraints?
There should be only one PRIMARY KEY
in a table whereas there can be
any number of UNIQUE Keys.
PRIMARY KEY doesn’t allow NULL
values whereas Unique key allows NULL values.Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
