/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 vote119 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote121 views1 answer
Sql shell psql cannot enter password
SQL
0 vote124 views1 answer
Renommer base sql
SQL
0 vote113 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote125 views1 answer
Mysql select smaller of two values
SQL
0 vote125 views1 answer
Oarcale list objects
SQL
0 vote129 views1 answer
Sqlite trim
SQL
14 votes130 views2 answers
Oracle add attribute to table
SQL
-2 votes124 views1 answer
How to open database
SQL
0 vote126 views1 answer
Insert output identity
SQL