/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 vote132 views1 answer
ORA-01950
SQL
1 vote142 views1 answer
Sqlite create index
SQL
0 vote131 views2 answers
Check mysql timezone
SQL
0 vote130 views1 answer
Sql server list user permissions
SQL
0 vote138 views1 answer
Oracle session statistics
SQL
0 vote163 views1 answer
How to pass list as parameter in SQL query
SQL
3 votes139 views2 answers
Sql get month name
SQL
0 vote138 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
16 votes126 views4 answers
Sort by sql
SQL
4 votes138 views2 answers
How to insert ip address in mysql using php
SQL