How to select only values for MAX(DATE)

Asked May 09 '22 at 20:56

Active May 09 '22 at 21:00

Viewed 448 times

I have done similar SQL queries in my opinion already before but this is somehow impossible although sounds easy... I hope you can help me in this, I have checked multiple answers for relating questions finding no working solution. I'm using SQL Developer.

I have two tables:

FAMILY

and FAMILY_PLAN

And I need to find only the newest FAMILY_PLAN to each person. And the answer should be like this:

Thank you for your help!

edited May 09 '22 at 20:58

MT0

143,790
11
59
117

asked May 09 '22 at 20:56

maijanen

Can you post the "Create table" script - are those date colums "date" or "varchar"? – JonTout May 09 '22 at 21:04
They are date columns – maijanen May 10 '22 at 06:04

How to select only values for MAX(DATE)

0 Answers0