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 vote224 views3 answers
Reseed sql table primary key
SQL
0 vote202 views1 answer
Disableforiegn key check
SQL
20 votes201 views3 answers
How to open postgresql in mac
SQL
0 vote247 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
2 votes198 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote243 views1 answer
Postgresql select fast check no rows
SQL
0 vote252 views4 answers
Best data type to represent money in mysql
SQL
1 vote206 views1 answer
Count mysql server db tables
SQL
0 vote182 views1 answer
List MySQL Table and Index Size
SQL
0 vote201 views1 answer
Kill thread
SQL