How to remove oldest row from pairs

Asked Nov 08 '21 at 21:43

Active Nov 08 '21 at 21:58

Viewed 17 times

I want to take a youngest row where the first two attributes can be paired.

example of table:

A | B | date
-----------------
6 | 2 | 10/01/21
2 | 6 | 09/01/21
5 | 6 | 10/01/21
6 | 5 | 05/01/21
1 | 6 | 11/01/21

I want choose youngest row between two rows (first and second cuz they are have same values).

In case in output I want have:

A | B | date
-----------------
6 | 2 | 10/01/21
5 | 6 | 10/01/21
1 | 6 | 11/01/21

Please help me :(

edited Nov 08 '21 at 21:58

asked Nov 08 '21 at 21:43

burzamiszcz

MySQL or SQLite, which is it? – Barmar Nov 08 '21 at 21:45
See https://stackoverflow.com/questions/1313120/retrieving-the-last-record-in-each-group-mysql?rq=1 – Barmar Nov 08 '21 at 21:46
There is no "first" or "second" row in an unordered set, you need to define how the rows are ordered. – Stu Nov 08 '21 at 21:50
@Barmar sqlite, mybad. – burzamiszcz Nov 08 '21 at 21:58
@Stu first and second like you can see in my post, I know that's not professional but I think you should understand :( – burzamiszcz Nov 08 '21 at 21:58
@burzamiszcz *I* understand what you mean - unfortunately the query engine does not. – Stu Nov 08 '21 at 22:04
@Stu I wrote my post for people, not for query engine :) – burzamiszcz Nov 08 '21 at 22:17

0 Answers0