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 vote114 views1 answer
Search In the Data using ObjectName
SQL
1 vote126 views1 answer
What is a Database?
SQL
0 vote112 views1 answer
Dapper run sql script with parameters
SQL
0 vote110 views1 answer
Sql count null as 0
SQL
9 votes121 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote112 views1 answer
Grouping by email domain mysql
SQL
2 votes119 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote127 views1 answer
Postrgres trunc
SQL
0 vote103 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote75 views1 answer
Count char in java
SQL