/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

6 votes124 views3 answers
Mysql first day of year
SQL
7 votes128 views2 answers
3rd height salary sql
SQL
1 vote122 views2 answers
How to enable error squiggles in vs code
SQL
-1 vote143 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote135 views1 answer
Get create sql of hibernqte entity
SQL
0 vote140 views1 answer
Declaring variables in pl sql
SQL
0 vote106 views1 answer
Sql new line output
SQL
0 vote124 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
1 vote119 views1 answer
Where database run
SQL
0 vote125 views1 answer
Postgresql copy backup table
SQL