/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

6 votes132 views1 answer
Oracle desc table primary key
SQL
14 votes134 views1 answer
Sql value of string
SQL
0 vote136 views1 answer
Use mysql in java program
SQL
0 vote117 views1 answer
Java input type sql date
SQL
13 votes130 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote131 views1 answer
Bigquery declare
SQL
1 vote95 views1 answer
Import in mysql without a software
SQL
-1 vote136 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote197 views1 answer
Sql to search who modified
SQL
6 votes121 views3 answers
Update with inner join postgres
SQL