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 vote201 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote837 views2 answers
Remove mysql workbench ubuntu
SQL
2 votes220 views1 answer
Oracle log files
SQL
0 vote190 views1 answer
Mariadb number format
SQL
0 vote217 views1 answer
Sql file in postgres with pgadmin
SQL
1 vote184 views1 answer
Can we drop a primary key
SQL
1 vote183 views1 answer
Mysql server does not start mac
SQL
0 vote184 views1 answer
Console output pl sql
SQL
0 vote197 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
2 votes201 views1 answer
How to get weekday from old date in sql
SQL