/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

2 votes182 views2 answers
Oracle create table if not exists
SQL
4 votes183 views1 answer
Add constraint fk
SQL
9 votes178 views1 answer
Mysql check date range
SQL
0 vote322 views1 answer
Mysql select field if condition
SQL
3 votes200 views2 answers
Laravel tosql with bindings
SQL
2 votes192 views1 answer
Oracle apex list connected users
SQL
0 vote178 views2 answers
Get top 1 row of each group
SQL
1 vote201 views2 answers
Sql server concat string and int
SQL
0 vote188 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote198 views1 answer
Qt qsql check if table exist
SQL