dlugirapfr
Registered User.
- Local time
- Today, 09:07
- Joined
- Nov 22, 2012
- Messages
- 68
Hi ,
I have table which looks like this
nr;amount;date
1;123;2020-04-01
2;321;2020-05-01
1;333;2020-04-03
3;111;2020-01-01
etc.
Which option of query I should make to receive result like this
nr;Maxamount1;date1;amount2;date2
1;333;2020-04-03;123;2020-04-01;
2;321;2020-05-01;
3;111;2020-01-01;
It should be some kind of union query? I have never use like this. Please give me some hint.
Thank you!
I have table which looks like this
nr;amount;date
1;123;2020-04-01
2;321;2020-05-01
1;333;2020-04-03
3;111;2020-01-01
etc.
Which option of query I should make to receive result like this
nr;Maxamount1;date1;amount2;date2
1;333;2020-04-03;123;2020-04-01;
2;321;2020-05-01;
3;111;2020-01-01;
It should be some kind of union query? I have never use like this. Please give me some hint.
Thank you!