/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 vote167 views2 answers
Sqlite unix timestamp
SQL
1 vote163 views1 answer
Drop table if exists oracle
SQL
27 votes230 views3 answers
Mysql delete row
SQL
3 votes174 views1 answer
Locate sql server
SQL
0 vote179 views1 answer
Oracle gather table statistics
SQL
1 vote178 views1 answer
Altrer name column postgres
SQL
0 vote183 views1 answer
Mysql value ends with
SQL
0 vote177 views1 answer
Microsoft sql server python connection
SQL
-1 vote152 views1 answer
Plsql while
SQL
0 vote160 views1 answer
Sqlalchemy.exc.OperationalError:
SQL