[firebird-support] crosstab pivot query

['Check_Mail' check_m...@satron.de [firebird-support]]

Hello,

 

I'm looking for an opportunity to create a crosstab (pivot) query, but I
can't get many examples from google.

 

For example:

 

Table A

Year, month, day, person, sign

2017  9         1      1        A

2017  9         2      1        B

2017  9         3      1        B

2017  9         ..30  1        C

2017  9         1      2        A

2017  9         ,,30  2       B

 

I woult like to get this:

 

Person         day1, day2, day3, day4, day5.day30

1                 A       B       B                          C

2                 A       B

 

Is this possible?

 

Many thanks.

 

Best regards

 

Olaf