/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

4 votes131 views1 answer
Oracle show errors compilation
SQL
8 votes131 views1 answer
Today minus 15 days postgresql
SQL
0 vote233 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
8 votes126 views1 answer
Oracle add month
SQL
0 vote133 views1 answer
Why we have to set the password for my sql server
SQL
0 vote137 views1 answer
Sql recherche nom prenom
SQL
0 vote176 views2 answers
Sql unique
SQL
0 vote129 views1 answer
Mysql Install Ubuntu with native password
SQL
2 votes141 views3 answers
Row number mysql
SQL
0 vote114 views1 answer
Create bakupd database sqlserver
SQL