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

6 votes170 views1 answer
Postgresql get year
SQL
0 vote133 views1 answer
How to reset AI in sql
SQL
3 votes99 views1 answer
Ubuntu install postgresql 12
SQL
0 vote160 views2 answers
Sql stored procedure for access frontend
SQL
0 vote147 views3 answers
Query string not ending with with vowels
SQL
6 votes144 views1 answer
How to count number of rows in sql
SQL
6 votes152 views1 answer
Allsource oracle
SQL
0 vote136 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote130 views1 answer
Update having mysql
SQL
0 vote135 views1 answer
Drop all tables db2
SQL