Get last date join sql

SELECT customer.*, purchase.*
FROM customer
JOIN (
   SELECT DISTINCT ON (customer_id) *
   FROM purchase
   ORDER BY customer_id, date DESC
) purchase ON purchase.customer_id = customer.id

Source: stackoverflow.com

Similar codes

0 vote137 views1 answer
How to get initials in sql
SQL
0 vote143 views1 answer
Call rest api from postgresql
SQL
1 vote156 views3 answers
Reset sql primary key
SQL
0 vote144 views1 answer
Use where instead of join
SQL
0 vote153 views1 answer
Postgres sequence name
SQL
0 vote141 views3 answers
Average salary in sql
SQL
1 vote146 views1 answer
Where date = max(date) in sql
SQL
1 vote155 views1 answer
How to use db.execute
SQL
0 vote136 views1 answer
Running query in redshift
SQL
3 votes146 views2 answers
Postgres inner join vs join
SQL