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

1 vote281 views1 answer
Sql set auto increment back to 0
SQL
0 vote245 views1 answer
Alasql delete column
SQL
0 vote287 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote265 views1 answer
Mysql join only one column
SQL
3 votes270 views2 answers
Mysql import gz
SQL
3 votes241 views1 answer
V$session not found in oracle
SQL
1 vote274 views1 answer
Oracle check table lock
SQL
6 votes275 views3 answers
Mysql remove user privileges
SQL
0 vote281 views1 answer
Pgadmin save data greyed out
SQL
0 vote253 views2 answers
Mysql password error create datbase
SQL