SQL Query

Hi All,
I have a table tbl_attendance with following data

course_id    batch_no   student_id      attendance_date     status
======      ======    =======   ==============   = ====
1                  Batch-1      A100         01/08/2012                  Present
1                  Batch-1      A100         02/08/2012                  Absent