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 vote190 views2 answers
Sql query in dax power bi
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
10 votes187 views3 answers
Insert into auto increment mysql
SQL
13 votes206 views2 answers
Sql online compiler
SQL
0 vote199 views1 answer
Horizontal join sqlite
SQL
1 vote176 views2 answers
Mysql type conversion
SQL
0 vote230 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote189 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote182 views3 answers
Above average salary in sql
SQL
0 vote207 views1 answer
Primary key start from number
SQL