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 vote180 views1 answer
Show database not empty tables postgres
SQL
5 votes215 views5 answers
Find max number in sql
SQL
-1 vote237 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote188 views1 answer
Mysql create index lost connection
SQL
0 vote181 views1 answer
Oracle call a function in a insert statement
SQL
3 votes187 views4 answers
Show databases in sql server
SQL
0 vote180 views1 answer
Database xml sql
SQL
0 vote235 views1 answer
Sql to excel pgadmin
SQL
11 votes192 views1 answer
Sql query to find duplicates in column
SQL
0 vote188 views1 answer
See the structure of a table mysql
SQL