/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

19 votes207 views6 answers
Mysql if null
SQL
0 vote197 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote213 views1 answer
Least spark sql
SQL
1 vote153 views1 answer
Athena query timestamp greater than
SQL
0 vote195 views1 answer
Sql server remove 0 from left
SQL
1 vote207 views1 answer
Mysql show data from table
SQL
25 votes234 views4 answers
Import mysql dump command line
SQL
0 vote192 views1 answer
Import all databases mysql
SQL
8 votes210 views1 answer
Check mysql version phpmyadmin
SQL
7 votes211 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL