How do I code a monthly attendance report in SQL?

Asked By Julia Daniele 60 points N/A Posted on - 04/06/2013

Hallo Guys! I am looking for a code that is capable of querying database generating a monthly attendance report in SQL. The code should be such that it adds the number of days that someone has attended. Comment on whether this code can be expanded to include fingerprint recognition to enable verification of persons. Cheers.

• Status: Open
• Question Views: 657
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Development Software

Answered By Miguel M Burch 50 points N/A #131881

How do I code a monthly attendance report in SQL?

You can first add the columns or rows using SUM then you can either subtract that with 28 or 29 for the month of February, and 30 or 31 for the other months of the year. You may also select the records before adding by month if there is a 'months' column in your database. After selecting, you may add the records. You can research more about SUM query from different websites like w3schools or at StackOverflow.

About Miguel M Burch

Questions
18

Answers
101

Best Answers
46

• Vote Up 0 Vote Down

• Posted on - 04/14/2013
• Question Category: Development Software