I am entering times from a Biometric device into a DB, that works fine.When I read the times
which has multiple rows per user for a day. eg..
ID DATE TIME
900 2012-25-03 07:00
901 2012-25-03 07:01
900 2012-25-03 13:00
900 2012-25-03 14:00
900 2012-25-03 16:00
What I want is in order to work out the times that has been worked for ID 900 I have to use the first instance and
the last instance for ID 900 for a particular day.
Is there a function available to read only this ?