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 vote229 views1 answer
Yesql
SQL
6 votes217 views2 answers
How to copy data in sql
SQL
1 vote212 views1 answer
Oracle transaction rollback not working
SQL
3 votes248 views1 answer
Mysql group_concat distinct
SQL
11 votes224 views3 answers
Python sqlite3 create table if not exists
SQL
10 votes224 views2 answers
Doublon sql
SQL
0 vote194 views1 answer
Recursive query herarchical data sql server
SQL
0 vote213 views1 answer
Set column in all row mysql
SQL
-2 votes229 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote196 views1 answer
SQL Server modify_timestamp trigger
SQL