/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

0 vote246 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote195 views1 answer
Porcentaje sql
SQL
4 votes208 views1 answer
Oracle session date format
SQL
16 votes228 views6 answers
Mysql find duplicates in same table
SQL
0 vote209 views1 answer
Selecting duplicates
SQL
20 votes200 views4 answers
Sqlite create table if not exists
SQL
2 votes196 views1 answer
SQL column name Postgre
SQL
1 vote205 views3 answers
Postgresql connect to database
SQL
0 vote216 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
2 votes206 views1 answer
How to delete view in sql
SQL