Sql unique

Sql unique select

SELECT DISTINCT col1, col2, ....
FROM table_name;

SELECT col1, MIN(col2)
FROM table_name
GROUP BY col1;

Sql unique

This constraint ensures all values in a column are unique.
Example 1 (MySQL): Adds a unique constraint to the id column when
creating a new users table.
CREATE TABLE users (
id int NOT NULL,
name varchar(255) NOT NULL,
UNIQUE (id)
);
Example 2 (MySQL): Alters an existing column to add a UNIQUE
constraint.
ALTER TABLE users
ADD UNIQUE (id);

Similar codes

0 vote381 views1 answer
Nodejs sql get one to many relationship as array
SQL
8 votes342 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote349 views1 answer
Mysql foreach insert
SQL
1 vote343 views1 answer
Media sql
SQL
0 vote335 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote370 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote363 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote372 views1 answer
Datagrip execute procedure
SQL
7 votes375 views5 answers
Oracle alter table
SQL
0 vote359 views1 answer
Mysql aspas simples
SQL