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

2 votes321 views1 answer
Q operator in oracle
SQL
0 vote268 views1 answer
Sqlite3 not commit
SQL
0 vote287 views1 answer
Oracle character index
SQL
0 vote289 views1 answer
Excute raw query
SQL
0 vote297 views1 answer
Selecting Data in SQL - Select Data
SQL
2 votes304 views1 answer
Sql server check for value in multiple columns
SQL
10 votes305 views6 answers
Sql between
SQL
0 vote306 views1 answer
Sql developer search all packages for text
SQL
3 votes279 views1 answer
Search for column name in psql
SQL
3 votes311 views1 answer
Postgresql today - 1 year
SQL