/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 vote321 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote323 views1 answer
OFFSET consulta mysql
SQL
0 vote358 views1 answer
Create table using the clause with as
SQL
0 vote291 views1 answer
Mysql with
SQL
0 vote344 views1 answer
Oracle string length
SQL
5 votes346 views3 answers
Sql server utc to local
SQL
-1 vote329 views1 answer
Concat two columns in sql server
SQL
0 vote324 views1 answer
Hoq to import database source
SQL
0 vote358 views1 answer
Error code 1451 sql
SQL
0 vote311 views1 answer
Sql select inside select sub query
SQL