/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

9 votes190 views3 answers
Pyodbc connect to sql server
SQL
0 vote142 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote154 views1 answer
Sql server isnull function nor working count
SQL
1 vote145 views1 answer
Oracle sql average
SQL
31 votes149 views2 answers
Grant all priviledges to mysql user
SQL
0 vote137 views1 answer
Postgresql delete multiple rows
SQL
0 vote168 views1 answer
When mysql server would not work in xampp
SQL
0 vote145 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
1 vote138 views4 answers
Get week day from date in sql
SQL
0 vote151 views1 answer
Mysql concatenate select results
SQL