/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 vote360 views1 answer
Php select data from mysql database without column name
SQL
2 votes382 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
2 votes403 views2 answers
Postgresql get table names
SQL
0 vote340 views1 answer
Mysql export data with a where clause
SQL
0 vote344 views1 answer
Remove default constraint sql server
SQL
5 votes353 views1 answer
Alter table add comment oracle
SQL
0 vote348 views1 answer
Mysql auto increment default value with prefix month and year
SQL
1 vote373 views1 answer
Postgresql append array
SQL
2 votes383 views1 answer
Sql server: select column values as comma separated string
SQL
-2 votes366 views1 answer
Mysql see users and passwords
SQL