SELECT DISTINCT Statement in SQL Server

SELECT DISTINCT Statement in SQL Server

The SELECT DISTINCT statement is used to return only distinct (different) output.

SELECT ItemName FROM Orders
SELECT Count(*) AS Countries
FROM (SELECT DISTINCT Country FROM Customers)

2020-03-04