/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

13 votes188 views6 answers
Current date sql
SQL
0 vote192 views1 answer
Sql convert datetime to year
SQL
2 votes196 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote209 views1 answer
Java sql insert return id
SQL
0 vote207 views2 answers
How to know the character set of an oracle databes
SQL
4 votes177 views1 answer
SQL order random
SQL
0 vote190 views2 answers
Mysql disable foreign key checks
SQL
0 vote188 views1 answer
Get employees if not contains in sql
SQL
1 vote202 views2 answers
Oracle difference between two dates in seconds
SQL
1 vote203 views1 answer
Decalre temp table sql
SQL