/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 vote368 views1 answer
Python sql last insertend
SQL
6 votes341 views1 answer
Oracle list primary key
SQL
0 vote362 views1 answer
Default column value in sql same as another column laravel
SQL
19 votes317 views1 answer
Sqrt(-1)
SQL
1 vote332 views2 answers
Last working day in week date function in sql
SQL
0 vote350 views1 answer
Open postgresql.conf in centos
SQL
49 votes384 views6 answers
Get duplicate records in sql
SQL
0 vote361 views2 answers
Mysql calcular idade
SQL
1 vote355 views1 answer
Mysql alter decimal precision
SQL
1 vote328 views2 answers
String to date postgres
SQL