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

0 vote306 views1 answer
Update top 100 order by sql server
SQL
-1 vote293 views1 answer
Mysql case when multiple conditions
SQL
0 vote300 views1 answer
Mysql join column order By and group By
SQL
0 vote284 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote280 views1 answer
How to convert DateTime to VarChar SQL
SQL
4 votes273 views1 answer
Mysql set max connections
SQL
0 vote228 views1 answer
Import sql file in mysql linux
SQL
0 vote289 views1 answer
Postgresql interview questions
SQL
1 vote294 views1 answer
Mysql current time
SQL
3 votes260 views1 answer
System.debug apex
SQL