akbar ansari

akbar ansari

  • 1.7k
  • 64
  • 2.1k

PIVOT table in sql

Mar 29 2023 10:55 AM
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)