/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

4 votes213 views1 answer
Sql query to make a existing column auto increment
SQL
6 votes240 views4 answers
Mysql group by date
SQL
0 vote225 views1 answer
Mysql remove last character
SQL
2 votes165 views1 answer
Oracle current date without time
SQL
2 votes216 views1 answer
Oracle find unusable indexes
SQL
0 vote229 views1 answer
Sql statement show all emails with dome
SQL
3 votes225 views2 answers
Oracle drop column
SQL
0 vote234 views1 answer
Postgresql create query
SQL
3 votes202 views1 answer
Insert into table from another table mysql
SQL
50 votes237 views4 answers
Sql alter type of column
SQL