Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mytable ( TeacherID varchar(3), RollNo number, Total_Absency number)
insert into mytable values('PNT', 1, 0)
1 rows affected

insert into mytable values('PNT', 2, 4)
1 rows affected

insert into mytable values('PNT', 3, 0)
1 rows affected

insert into mytable values('PNT', 4, 1)
1 rows affected

insert into mytable values('SGP', 1, 2)
1 rows affected

insert into mytable values('SGP', 2, 1)
1 rows affected

insert into mytable values('SGP', 3, 1)
1 rows affected

insert into mytable values('SGP', 4, 1)
1 rows affected

insert into mytable values('DAP', 1, 1)
1 rows affected

insert into mytable values('DAP', 2, 1)
1 rows affected

insert into mytable values('DAP', 3, 1)
1 rows affected

insert into mytable values('DAP', 4, 0)
1 rows affected

SELECT * FROM
(
  SELECT TeacherID, RollNo, Total_Absency FROM mytable
)
PIVOT 
(
  MAX(Total_Absency)
  FOR TeacherID
  IN ( 'PNT', 'SGP', 'DAP' )
)
ORDER BY RollNo


ROLLNO
'PNT'
'SGP'
'DAP'


1
0
2
1

2
4
1
1

3
0
1
1

4
1
1
0