/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 vote171 views1 answer
How to install Firebird
SQL
15 votes190 views5 answers
If null mysql
SQL
0 vote189 views1 answer
T-SQL Never ending DELETE
SQL
0 vote228 views1 answer
Reset a table's identity column and remove test records
SQL
5 votes180 views1 answer
Sort order on two columns sql
SQL
0 vote185 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
6 votes193 views2 answers
Mysql interval 1 day
SQL
0 vote181 views1 answer
Show size of all tables postgres
SQL
0 vote156 views1 answer
Ms sql unique
SQL
1 vote192 views1 answer
Sql avg group by
SQL