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

2 votes383 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote359 views1 answer
Tsql generate rows
SQL
1 vote351 views1 answer
Importance of comment in mysql
SQL
0 vote357 views1 answer
Sql server datetime to string
SQL
0 vote408 views1 answer
Mysql get first 2 characters of string
SQL
50 votes495 views6 answers
Sql count duplicate rows
SQL
0 vote399 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote370 views1 answer
Oracle sequence last_number
SQL
5 votes392 views1 answer
Mysql add user with all privileges
SQL
-1 vote305 views3 answers
Ubuntu install mssql
SQL