Disting sql

Disting

it allows us to draw the data that repeats in the table as one.

SELECT DISTINCT column1, column2, …
FROM table_name;

SELECT DISTINCT Examples
The following SQL statement selects only the DISTINCT values from the “Country” column in the “Customers” table:

Example

SELECT DISTINCT Country FROM Customers;
The following SQL statement lists the number of different (distinct) customer countries:

Leave a Reply