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 vote175 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote163 views1 answer
Remove transient options sql wordpress
SQL
0 vote140 views1 answer
Mysql jdbc timezone
SQL
1 vote148 views1 answer
SQL query to get all table records count from a database
SQL
0 vote168 views1 answer
Repeatable read trong sql server
SQL
5 votes150 views3 answers
Mysql update field from one table to another
SQL
5 votes140 views1 answer
Postgresql functions
SQL
0 vote158 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
8 votes166 views1 answer
Oracle add datafile to tablespace
SQL
1 vote140 views1 answer
Group_concat max length mysql
SQL