Unique vs primary key

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.

Similar codes

0 vote101 views1 answer
Mysql collation for all languages
SQL
0 vote135 views1 answer
How to install sql in anaconda
SQL
0 vote132 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
21 votes140 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote136 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote137 views1 answer
Sql: extract day text from datetime value
SQL
13 votes151 views2 answers
Sql join 3 tables
SQL
3 votes95 views1 answer
Postgresql where current year
SQL
0 vote121 views1 answer
Sub blocks in sql
SQL
0 vote142 views1 answer
Open postgresql.conf in centos
SQL