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

3 votes254 views2 answers
Enter mysql command line
SQL
1 vote204 views1 answer
Postgres first_value in gropby
SQL
0 vote240 views1 answer
How to open mysql in docker
SQL
0 vote199 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote212 views1 answer
Sql server separar numeros por comas miles
SQL
6 votes196 views2 answers
Mysql set primary key
SQL
0 vote214 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
4 votes244 views5 answers
Get last query in codeigniter 4
SQL
0 vote185 views1 answer
Create date sql
SQL
1 vote202 views1 answer
GROUP BY clause; this is incompati
SQL