/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 vote116 views1 answer
Delet all record statment sql
SQL
0 vote93 views1 answer
How many rows affected in sqllite
SQL
0 vote104 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
2 votes108 views2 answers
Postgresql get table names
SQL
0 vote111 views1 answer
Less mysql display
SQL
1 vote101 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote109 views1 answer
Sqlalchemy get ids
SQL
11 votes96 views2 answers
Oracle all source
SQL
1 vote107 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
1 vote93 views1 answer
Nested if in mysql
SQL