sql select distinct

1SELECT DISTINCT column1, column2, ...
2
3 FROM table_name; 

1insert into your_table (col1, col2, col3)
2select distinct col1, 'newval', col3
3from your_table

1When querying data from a table, you may get duplicate rows. In order to remove these duplicate rows, you use the DISTINCT clause in the SELECT statement.
2
3Here is the syntax of the DISTINCT clause:
4
5SELECT DISTINCT
6    select_list
7FROM
8    table_name;

1SELECT DISTINCT ma_colonne
2FROM nom_du_tableau

1SELECT DISTINCT column1, column1, ..... FROM TABLE
2/*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/

1SELECT Country FROM Customers;