/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

1 vote323 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote336 views1 answer
Select from column mysql
SQL
1 vote320 views1 answer
How to give access to database in postgresql server to another user
SQL
24 votes336 views4 answers
Postgres remove database
SQL
1 vote327 views1 answer
Pagination sql
SQL
0 vote319 views1 answer
Min salary in sql
SQL
-2 votes325 views1 answer
Modify column name in tsql
SQL
0 vote350 views1 answer
Mysql set variable to today's date
SQL
16 votes309 views2 answers
Gremove folder from git
SQL
5 votes341 views1 answer
Invalid column name sql
SQL