sql select row with max value if multiple exists if not select the available row

Question

i have this sql table and i want to query the rows with max date if multiple ones exists with the same num if theres no multiple colomns just get the existing row for example on this table

Num	date
1	1990/01/01
1	2020/12/31
2	1990/01/01
2	2020/12/31
3	Null

the result should be :

Num	date
1	2020/12/31
2	2020/12/31
3	Null

Does this answer your question? [Get top 1 row of each group](https://stackoverflow.com/questions/6841605/get-top-1-row-of-each-group) — Charlieface, Jan 21 '22 at 12:31

score 1 · Accepted Answer · answered Jan 21 '22 at 11:03

1

try the below, but it does depend on which db you are using:

select num, max(date) from XTableNameX group by num

answered Jan 21 '22 at 11:03

DaveWuzHere

213
2
7

sql select row with max value if multiple exists if not select the available row

1 Answers1