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

2 votes111 views2 answers
Run mysql command from bash
SQL
34 votes123 views6 answers
Install mysql client ubuntu
SQL
0 vote110 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote109 views1 answer
How to login to mysql in homestead
SQL
0 vote113 views1 answer
Set root password mysql xampp
SQL
0 vote104 views1 answer
Xampp mysql version
SQL
0 vote120 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote108 views1 answer
Sqlcmd no headers
SQL
0 vote106 views1 answer
Postgres week number
SQL
0 vote156 views1 answer
Restart serial number for postgres
SQL