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 vote295 views1 answer
Mysql date only no time
SQL
0 vote337 views1 answer
Postgres list users and roles
SQL
10 votes325 views2 answers
Mysql alter add foreign key
SQL
19 votes329 views6 answers
Mysql if null
SQL
25 votes310 views6 answers
Sql update query
SQL
0 vote309 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote327 views1 answer
Spark sql convert string to date
SQL
0 vote313 views1 answer
Create schema sql server
SQL
0 vote363 views1 answer
Sql datum formatieren
SQL
3 votes298 views5 answers
Mysql get last inserted id
SQL