Postgresql left join distinct on

Select Distinct On (u.username, u.email)
     u.username
    ,u.email
    ,l.browser
    ,l.login_time
From users u
Join logins l On l.username = u.username
Order By u.username, u.email, login_time Desc
 
                                        ^

Source: noelherrick.com

Similar codes

-1 vote227 views2 answers
Postgresql get last 10 records
SQL
-1 vote222 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote225 views2 answers
Default constraint in ms sql
SQL
1 vote231 views1 answer
Postgres check for foreign key
SQL
0 vote218 views1 answer
Postgresql find missing id
SQL
0 vote222 views1 answer
Flask sqlalchemy decimal
SQL
2 votes227 views1 answer
Mysql application.properties spring boot
SQL
2 votes235 views1 answer
How to get weekday from old date in sql
SQL
1 vote240 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote233 views1 answer
Sql server sleep
SQL