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 vote247 views3 answers
Convert sql query to python pandas
SQL
0 vote251 views1 answer
Import sql inside hide sql
SQL
0 vote258 views1 answer
Sql server express download
SQL
2 votes264 views1 answer
Sql server: select column values as comma separated string
SQL
2 votes251 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote246 views1 answer
Mysql command prompt date insert format
SQL
0 vote253 views1 answer
Mysql add root password
SQL
2 votes275 views3 answers
Mysql kill
SQL
2 votes252 views1 answer
Oracle sql concatenate results into string
SQL
1 vote260 views1 answer
Mysql data from file
SQL