How to use distinct in SQL?

Question

Can anyone tell me how to use distinct in SQL?

Answer 1

Here is the syntax to use distinct in SQL:

SELECT DISTINCT column_list

FROM TableName;

Suppose you want to find the countries of customers from ‘Customers’ table:

SELECT DISTINCT Country

FROM Customers;

This is the basic example of using DISTINCT. For complex queries, you can check out this SQL tutorial by Intellipaat.