Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Selecting rows with distinct values for a column. RE: Selecting rows with distinct values for a column.

  • June 12, 2013 at 3:42 pm

    #1623522

    Luis Cazares (6/12/2013)

    As easy as

    SELECT UserID,

    MAX(Email) Email

    FROM MyTable

    If you need a specific email, you need to define the priority.

    Yep, easy except you are missing something:

    SELECT

    UserID,

    MAX(Email) Email

    FROM

    MyTable

    GROUP BY

    UserID;