2
Answers

PIVOT table in sql

akbar ansari

akbar ansari
1y
544
1
Date TYPE TIME
01-01-2020 A 01:20
01-01-2020 B 20:30
02-01-2020 A 10:01
02-01-2020 B 10:20
03-01-2020 A 11:01
03-01-2020 B 11:10
04-01-2020 A 11:21
04-01-2020    
till month end more TYPE (A,B)... more times....(different times)

How can i present table in

TYPE 01-01-2020 02-01-2020 03-01-2020 04-01-2020 05-01-2020 06-01-2020 07-01-2020
A 01:20 10:01          
B 20:30 10:20          
Answers (2)
Next Recommended Forum