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

31 votes318 views4 answers
Mysql grant execute
SQL
1 vote326 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote310 views2 answers
Nosqlbooster query other collection
SQL
0 vote303 views1 answer
Sql server beginning of month
SQL
0 vote334 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote318 views1 answer
Grant privileges of databse to user
SQL
8 votes452 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote305 views1 answer
Python sqlalchemy orm to select null values
SQL
2 votes287 views1 answer
Docker run postgres locally
SQL
0 vote317 views1 answer
Authentication modes in sql server
SQL