/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 vote245 views1 answer
How to input data as id in database sql c#
SQL
0 vote197 views1 answer
Find invalid datetime field
SQL
0 vote196 views1 answer
Addition of 2 column value in mysql
SQL
2 votes193 views1 answer
Get first n letter of department name in sql
SQL
1 vote196 views1 answer
Psql filed name alter
SQL
0 vote181 views1 answer
Knex last insert id mysql
SQL
0 vote195 views1 answer
Json not contains mysql
SQL
1 vote196 views1 answer
Sql trigger before delete
SQL
0 vote197 views2 answers
Oracle create chain rule
SQL
3 votes235 views1 answer
Ms sql skip take
SQL