Scribd
Upload
33 views1 page

SQL Test:: S.No. Name Last 2 Days Absent 1. Amit Yes 2. Ravi No

The document contains a student attendance sheet with names and attendance status for multiple dates and asks to write SQL code to output a report showing students who were absent in the last two days with their name and an indicator of their absence status.

Uploaded by

bellum charan kumar charan kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
33 views1 page

SQL Test:: S.No. Name Last 2 Days Absent 1. Amit Yes 2. Ravi No

The document contains a student attendance sheet with names and attendance status for multiple dates and asks to write SQL code to output a report showing students who were absent in the last two days with their name and an indicator of their absence status.

Uploaded by

bellum charan kumar charan kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

SQL Test:

Student Attendance sheet:


[Link] Name Date Attendance
1. Amit 1/1/2021 Present
2. Ravi 1/1/2021 Absent
3. Amit 2/1/2021 Present
4. Ravi 2/1/2021 Absent
5. Amit 3/1/2021 Absent
6. Ravi 3/1/2021 Present
7. Amit 4/1/2021 Absent
8. Ravi 4/1/2021 Present

Using the above Above Attendance Sheet show the Students who are Absent last two days:

Example like:
[Link]. Name Last 2 days Absent
1. Amit Yes
2. Ravi No

Write your own SQL code to achieve reort to show students who are last two days absent.

You might also like