- Learn T-SQL Querying
- Pedro Lopes Pam Lahoud
- 31字
- 2021-06-24 14:38:08
DISTINCT
DISTINCT specifies that repeated rows in the result set are collapsed into a single row.
SELECT DISTINCT Name AS ProductName, LEFT(ProductNumber, 2) AS ProductCode, ISNULL(color, 'No Color') AS Color [...]