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

10 votes262 views2 answers
Django mysql
SQL
0 vote331 views1 answer
Write SQL in ruby on rails
SQL
0 vote299 views1 answer
Sql server isnull function nor working count
SQL
10 votes305 views1 answer
User_dependencies
SQL
0 vote310 views1 answer
Count database access django
SQL
0 vote299 views1 answer
Mysql preg replace
SQL
0 vote284 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote313 views1 answer
Alter check command
SQL
1 vote313 views1 answer
Postgres power
SQL
2 votes249 views1 answer
Sql view column data type
SQL