/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

1 vote338 views1 answer
Search for tables with name postgresql
SQL
-1 vote312 views1 answer
Plsql while
SQL
34 votes382 views6 answers
Install mysql client ubuntu
SQL
2 votes354 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote326 views1 answer
Check if a word appears at the end sql query
SQL
0 vote368 views2 answers
Dumping sql table
SQL
0 vote366 views1 answer
Get schema of table sql
SQL
3 votes432 views1 answer
Oracle list invalid password logon denied
SQL
14 votes334 views2 answers
Sql cast
SQL
1 vote334 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL