/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 vote234 views1 answer
Varchar format not case sensitive sql
SQL
4 votes231 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote237 views1 answer
Connect laravel to mysql on mac
SQL
3 votes245 views2 answers
Mysql import gz
SQL
0 vote225 views4 answers
How to drop all tables in sql
SQL
4 votes232 views2 answers
Postgresql default value
SQL
0 vote236 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote230 views1 answer
How to find the most occuring in SQL
SQL
11 votes235 views3 answers
Sqlite3 create table from another table
SQL
1 vote229 views1 answer
Sqlite create index
SQL