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 vote103 views1 answer
Check message id sql server
SQL
0 vote104 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote129 views1 answer
Table user postgres
SQL
20 votes119 views6 answers
Creating a table in sql
SQL
3 votes107 views1 answer
Make a field auto_increment mysql
SQL
7 votes113 views5 answers
Sql remove spaces
SQL
0 vote97 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote121 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
7 votes123 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote102 views1 answer
Sql select column names starting with
SQL