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 vote235 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote229 views1 answer
Mariadb maximum left join
SQL
1 vote229 views1 answer
Insert column after column mysql
SQL
0 vote229 views1 answer
Sql replace id with name from another table
SQL
0 vote242 views4 answers
User defined function sql
SQL
1 vote250 views1 answer
Mysql curdate between two dates
SQL
9 votes220 views4 answers
How to remove duplicate in sql
SQL
2 votes236 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
17 votes265 views2 answers
T_sql contains
SQL
0 vote220 views1 answer
View acl table oracle
SQL