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 vote233 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote191 views1 answer
Postgresql auto increment not working
SQL
1 vote252 views1 answer
Top 10 rows in mysql
SQL
1 vote196 views5 answers
Postgresql difference between two dates in days
SQL
5 votes183 views1 answer
Oracle ORA-00054 origin
SQL
0 vote196 views1 answer
Mysql grouping functions
SQL
0 vote244 views1 answer
Create table as select sql server error
SQL
0 vote263 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote186 views1 answer
FIND most frequent word in sql server
SQL
23 votes154 views3 answers
Mysqldump
SQL