/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

0 vote333 views1 answer
Sql get highest date from 3 tabels
SQL
4 votes326 views3 answers
How to describe a table in sqlite3
SQL
0 vote327 views1 answer
Désinstaller postgresql linux
SQL
0 vote393 views1 answer
Reindexing all tables sql server
SQL
0 vote318 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote527 views1 answer
Multiple row join
SQL
4 votes331 views2 answers
Oracle default date format
SQL
1 vote363 views3 answers
Read all columns of a table sql
SQL
0 vote335 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
-1 vote326 views1 answer
Extract Data from SQL Server into XML Format
SQL