MySQL Forums
Forum List  »  InnoDB

Absent List.
Posted by: naresh kumar
Date: April 18, 2009 02:19AM

Hello Gurus,

I need a solution to which i think more typical.
I have a table with columns date and attendance.
2009-04-01 P
2009-04-02 A
2009-04-03 A
2009-04-04 P
2009-04-05 A
2009-04-06 A
2009-04-07 A
2009-04-08 A
2009-04-09 P
2009-04-10 A

I need continuous absent count for doing some calculations.
I need all absents like 2,4,1.

Can I get this through queries.

Thanks in advance,

Options: ReplyQuote

Written By
Absent List.
April 18, 2009 02:19AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.