How to write this sql?
Posted by:
邦 周
Date: July 10, 2020 11:02PM
Hi,
How to write sql to get date from table A, and format it to table B use MySQL?
Thanks!
======Table A======
Type++++++Date
C--------2019-1
B--------2019-1
C--------2019-4
C--------2019-4
C--------2019-4
C--------2019-5
B--------2019-5
C--------2019-7
B--------2019-8
B--------2019-10
C--------2019-12
C--------2019-12
A--------2019-8
C--------2019-6
C--------2019-3
B--------2019-3
B--------2019-4
C--------2019-4
B--------2019-4
A--------2019-4
======Table B======
Date++++++++++A++++++++B++++++++C
2019-1--------2--------16--------21
2019-2--------3--------8--------20
......
Subject
Written By
Posted
How to write this sql?
July 10, 2020 11:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.