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

1 vote309 views1 answer
Sql server reseed single table
SQL
-1 vote314 views1 answer
Ssms connect with connection string
SQL
0 vote318 views1 answer
Postgres declare variable
SQL
0 vote324 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
1 vote339 views1 answer
Postgres cast as currency format
SQL
7 votes311 views2 answers
N highest salary in sql
SQL
0 vote310 views1 answer
Sql server whoami
SQL
0 vote309 views1 answer
Mysql database is not starting in xampp
SQL
6 votes315 views2 answers
Mysql first day of month
SQL
6 votes328 views2 answers
Where clause in sql
SQL