mysql - 在 MySQL 查询中将行转换为列

Question

我从这个查询中得到了以上结果

   SELECT sa.Student_Id,
   CONCAT_WS(' ', es.Student_FName, es.Student_LName) AS Full_Name, 
   sa.Attendance_Date ,  
   sa.Attendance_Status 
   FROM student_attendance sa 
   INNER JOIN courses c 
     ON c.Course_Id = sa.Course_Id
   INNER JOIN campus ca 
     ON ca.Campus_Id = c.Campus_Id
   INNER JOIN students es 
     ON es.Student_Id =  sa.Student_Id
   WHERE sa.Course_Id = 1  
     ORDER BY sa.Attendance_Date DESC;  

但我想要这个结果

有人可以帮我做这个吗..

Answer 1

     select max(student|_id),full_name as student_FName ,
     case attendance_date when attendance_date ='03-02-2016' and attendance_status =0 
     and full_name ='Shehriar Khan'
     Then 'p' end as '3/1/2016',
     case attendance_status when attendance_date ='03-01-2016' 
     and attendance_status =0 and full_name ='Ahtesham Illahi'
     Then 'p' end as '3/2/2016'
     from table_name 
     group_by full_name,attendance_date,attendance_stauts