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 votes257 views1 answer
Oracle cpu per session
SQL
0 vote252 views2 answers
What is 1=2 in sql
SQL
36 votes335 views6 answers
Change column data type sql
SQL
0 vote251 views1 answer
Difference between 2 query results sql server
SQL
0 vote258 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote256 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote296 views1 answer
Table structure in sql
SQL
0 vote275 views1 answer
Mysql aspas simples
SQL
1 vote279 views1 answer
How to see logical reads in sql server
SQL
0 vote297 views1 answer
Sql server phone constraint
SQL