/SQL/Sql server select rows by distinct column

Sql server select rows by distinct column

SELECT a.*
FROM emails a
INNER JOIN 
  (SELECT email,
    MIN(id) as id
  FROM emails 
  GROUP BY email 
) AS b
  ON a.email = b.email 
  AND a.id = b.id;

Source: stackoverflow.com

Similar codes

6 votes236 views3 answers
Commit in sql
SQL
1 vote266 views1 answer
Sql server set variable if exists
SQL
0 vote251 views2 answers
Mysql show foreign keys
SQL
1 vote247 views1 answer
Print year of a date sql
SQL
0 vote266 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote216 views1 answer
Take sql dump in to file
SQL
0 vote250 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
8 votes241 views10 answers
Sql
SQL
0 vote230 views1 answer
Space not removing from column in sql
SQL
0 vote225 views1 answer
Contraint default SQL
SQL