SQL SERVER – DISTINCT Keyword Usage and Common Discussion | Journey to SQL Authority with Pinal Dave

Jr. DBA asked me a day ago, how to apply DISTINCT keyword to only first column of SELECT. When asked for additional information about question, he showed me following query. SELECT Roles, FirstName, LastName FROM UserNames He wanted to apply DISTINCT to only Roles and not across FirstName and LastName. When he finished I realize… Continue Reading...

Source: SQL SERVER – DISTINCT Keyword Usage and Common Discussion | Journey to SQL Authority with Pinal Dave