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

1 vote272 views1 answer
Insert column after column mysql
SQL
0 vote292 views1 answer
How to write if case in select query in select statement
SQL
0 vote259 views1 answer
Power bi dax add related shows column but not working
SQL
1 vote276 views1 answer
Load mysql dumb
SQL
18 votes266 views3 answers
Mysql current date
SQL
0 vote287 views1 answer
Mysql where in maintain order
SQL
0 vote284 views1 answer
How to query without duplicate rows in sql
SQL
0 vote281 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
10 votes297 views2 answers
What is database
SQL
0 vote292 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL