/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

5 votes361 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
3 votes368 views1 answer
Increment integer in table sql
SQL
1 vote288 views1 answer
Prevent duplicate rows in postgres
SQL
1 vote342 views1 answer
Get last week data in mysql
SQL
9 votes388 views2 answers
Nosql databases
SQL
0 vote306 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote340 views1 answer
Sql anywhere create procedure
SQL
8 votes359 views1 answer
Oracle search code in packages
SQL
0 vote362 views1 answer
C# get sql min date
SQL
0 vote387 views1 answer
Create a view in sqlite
SQL