/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

3 votes266 views3 answers
Mysql get table size
SQL
1 vote275 views1 answer
Oracle activate job
SQL
4 votes275 views2 answers
Sql table
SQL
0 vote289 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote287 views1 answer
Mql5 datetime get hour
SQL
0 vote261 views1 answer
Sql examples from your work
SQL
1 vote315 views1 answer
Oracle show execution plan
SQL
0 vote278 views2 answers
Create fulltext index mysql
SQL
19 votes289 views6 answers
Sql drop table if exists
SQL
1 vote292 views1 answer
Psql import backup file for windows
SQL