T-SQL 101: #18 - Removing duplicate rows by using DISTINCT

added by DotNetKicks
6/20/2019 1:39:41 PM

1 Kicks, 125 Views

If I query rows from a SQL Server table, I don't always want all the rows returned. In particular, I might not want any duplicates. I can remove them by using DISTINCT. Here's a simple example. I want a list of the sizes that products can come in, so I execute this query: Note that ...