distinct in sql

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

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*/

1Distinct: helps to displays the non duplicate
2records when retrieving the records from a table.
3
4SELECT DISTINCT FIRST_NAME FROM VISITORS;

1SELECT DISTINCT FIRST_NAME FROM VISITORS;