/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 vote268 views1 answer
Count mysql server db tables
SQL
1 vote263 views1 answer
What is intersect
SQL
0 vote270 views1 answer
Oracle merge insert if not exists
SQL
0 vote293 views1 answer
000webhost database values insert
SQL
0 vote268 views1 answer
Update if else mysql
SQL
0 vote269 views1 answer
Regex mongoose
SQL
8 votes275 views1 answer
Unique vs primary key
SQL
0 vote274 views1 answer
Reset postgresql password windows
SQL
0 vote266 views2 answers
T SQl Checking Your Username
SQL
0 vote271 views1 answer
Check for directory in bash
SQL