/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

1 vote116 views1 answer
Add sequence postgres
SQL
0 vote112 views1 answer
Creation d'un trigger sql
SQL
1 vote114 views1 answer
Mysql add fields
SQL
21 votes104 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote104 views1 answer
Add multiple field in table sql
SQL
0 vote105 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote65 views1 answer
Postgresql subquery
SQL
8 votes115 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote112 views1 answer
Sqlite commands
SQL
0 vote78 views2 answers
Avg() sql
SQL