/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

13 votes137 views6 answers
Current date sql
SQL
2 votes134 views2 answers
How to create an empty table from an existing table
SQL
0 vote177 views1 answer
Start stop mysql linux
SQL
0 vote163 views1 answer
Command to give readonly access to a postgres sql user
SQL
1 vote141 views2 answers
Drop function in sql
SQL
49 votes242 views6 answers
Mysql add column to table
SQL
0 vote160 views1 answer
Sql out file formate
SQL
0 vote151 views1 answer
How to run mysql in git bash
SQL
0 vote142 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote145 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL