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 vote317 views1 answer
Mysql case when on date
SQL
0 vote274 views1 answer
Mysql:5.6 syntax create table
SQL
-2 votes279 views1 answer
Mysql not empty
SQL
1 vote335 views1 answer
Oracle select first row order by
SQL
2 votes284 views1 answer
Possgress drop if exists table
SQL
0 vote300 views1 answer
Sql server list table sizes
SQL
0 vote335 views1 answer
Psql check if sql script is valid
SQL
0 vote292 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote300 views1 answer
Code to move ietms from one table to another myswl
SQL
2 votes292 views1 answer
Sql get the name of user pc
SQL