1 month ago

Grouping Queries

Posted 1 month ago by InspiredPrynce

Hello guys...

I have an attendance app that takes the attendance of the staff of a place, the attendance table stores the sign in as a new row and the sign out as a new row as well. The table structure goes like this...

staff_id, status, sign_type, date_signed

so i want to fetch the data in a grouped format so a staff's sign in and out records for a day can be grouped as 1..

How do i do that?

Please sign in or create an account to participate in this conversation.