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 vote184 views4 answers
Mysql select bottom 10 rows
SQL
0 vote175 views1 answer
How to get initials in sql
SQL
0 vote196 views1 answer
Create column that already exists mysql
SQL
0 vote152 views2 answers
Postgresql could not start server mac
SQL
1 vote326 views1 answer
Postgres set column based on another column
SQL
0 vote196 views1 answer
SqlFunction does not exist
SQL
0 vote193 views1 answer
MySQL - Enabling the Event Scheduler
SQL
15 votes178 views7 answers
MYSQL
SQL
1 vote197 views1 answer
Mysql pretty date format
SQL
0 vote179 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL