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 vote154 views1 answer
Mysql strict_trans_tables
SQL
0 vote144 views1 answer
If column value is null then in mysql
SQL
0 vote145 views1 answer
Count number of entires by months sql
SQL
0 vote140 views1 answer
Rabbitmq ui not working
SQL
0 vote149 views1 answer
Select insert new table sql server
SQL
0 vote131 views1 answer
Mysql create table columns with spaces
SQL
9 votes133 views3 answers
Mysql show table column full description
SQL
1 vote142 views1 answer
Type int in mysql maxlenght
SQL
0 vote149 views1 answer
Regex any word except sql
SQL
4 votes129 views2 answers
Tsql utf to local time
SQL