distinct clause in SQL

The DISTINCT clause is used in the SELECT statement to remove duplicate rows from a result set. The DISTINCT clause keeps one row for each group of duplicates. The DISTINCT clause can be applied to one or more columns in the select list of the SELECT statement.
If you specify multiple columns, the DISTINCT clause will evaluate the duplicate based on the combination of values of these columns.
The following illustrates the syntax of the DISTINCT clause:
```
SELECT
   DISTINCT column1, column2
FROM
   table_name;
```
In this case, the combination of values in both column1 and column2 columns will be used for evaluating the duplicate.
Home