There may be a situation you may want PIVOT rows to column and vice versa. Netezza don't have PIVOT function like other RDBMS. Netezza Pivot rows to column and column to row requires the CASE or DECODE statements. Netezza PIVOT Rows to Column Let us consider the below input data TRAINING.ADMIN(ADMIN)=> select * from students; CLASS | SECTION | PASS_FAIL | COUNT --------+---------+-----------+------- CLASS2 | B | FAIL | 333 CLASS2 | B | PASS | 543 CLASS1 | A | FAIL | 123 CLASS1 | A | PASS |…