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 vote356 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote364 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote372 views1 answer
Convert multiple columns to ROws in sql server
SQL
-1 vote338 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
3 votes371 views2 answers
How to load files in mysql
SQL
0 vote372 views1 answer
On delete set default
SQL
0 vote374 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
6 votes340 views2 answers
WHERE value IS sql
SQL
15 votes349 views4 answers
T-sql drop function if exists
SQL
1 vote350 views1 answer
Moodle query first user access
SQL