/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

0 vote147 views1 answer
Oracle current timestamp insert statement
SQL
0 vote175 views1 answer
Local pg_sql to heroku pg_sql
SQL
4 votes107 views2 answers
Create table if not exists postgres
SQL
0 vote138 views1 answer
Mysql concat and use as where column
SQL
25 votes241 views6 answers
Change column name mysql
SQL
0 vote147 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
7 votes140 views3 answers
Postgresql dump and restore db
SQL
0 vote147 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
9 votes167 views3 answers
Where clause sql
SQL
3 votes144 views2 answers
Brew start mysql
SQL