/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

12 votes270 views6 answers
How to install sqlite3 in python
SQL
0 vote367 views1 answer
Sql insert exemplo
SQL
0 vote244 views1 answer
Show all mongodb
SQL
8 votes270 views1 answer
Sql limit results returned
SQL
0 vote275 views1 answer
Postgresql list extensions
SQL
0 vote268 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote288 views1 answer
Oracle pl/sql check if file exists
SQL
1 vote258 views1 answer
Mysql tables max count
SQL
0 vote264 views1 answer
Provide hardcoded value in the mysql query
SQL
6 votes255 views2 answers
Clear a table in mysql
SQL