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

1 vote115 views2 answers
Oracle list service names
SQL
16 votes113 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote103 views1 answer
Check duplicate values plsql
SQL
5 votes121 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote230 views1 answer
Sql change a colum to unique
SQL
0 vote153 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
13 votes110 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote129 views1 answer
Hallo
SQL
0 vote130 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
2 votes108 views1 answer
How to search table name in stored procedure in sql server
SQL