/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 vote271 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
-1 vote284 views5 answers
Left join
SQL
0 vote287 views1 answer
What is database username and password in mysqliconnect
SQL
2 votes258 views1 answer
Drop table purge
SQL
0 vote268 views1 answer
Postgresql comandos basicos
SQL
0 vote258 views1 answer
Mysql two joins
SQL
0 vote271 views1 answer
Flask sqlalchemy session delete
SQL
2 votes270 views5 answers
SQL trigger
SQL
1 vote257 views1 answer
Oracle sql assign unique number to each grouping
SQL
4 votes254 views3 answers
Create database in mySQL
SQL