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 vote327 views1 answer
Add multiple row table pl sql
SQL
0 vote315 views1 answer
Monthly Birthday SQL Query
SQL
0 vote303 views1 answer
Sql select most frequent value in group
SQL
0 vote309 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote316 views1 answer
Report in database
SQL
3 votes298 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote303 views1 answer
How to print out column name differently in mysql
SQL
2 votes304 views1 answer
Drop table if exists in postgres
SQL
13 votes330 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
1 vote308 views1 answer
Get rows affected mysql python
SQL