/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

3 votes195 views2 answers
Wp do sql query from function
SQL
0 vote119 views2 answers
Sql update from two different database
SQL
0 vote193 views1 answer
Grouping by email domain mysql
SQL
1 vote150 views1 answer
Pv mysql import
SQL
2 votes158 views1 answer
How to get weekday from old date in sql
SQL
0 vote186 views1 answer
Time data type in mysql
SQL
10 votes157 views1 answer
Oracle dba_dependencies
SQL
0 vote170 views1 answer
Mysql get nth highest
SQL
1 vote164 views1 answer
Sql server: query to find out all the places where the table is used
SQL
2 votes145 views1 answer
Rails execute sql
SQL