how to filter in sql
- by user3634746
good day i have a database containing time in and time out and i want to filter all the record of the employees time in and time out. here is my sample db using php and mysql
PersonalId LogCount LogDate LogType LogKind
2 1 2014-04-09 12:42:24 0 0
2 1 2014-04-10 12:43:53 1 0
2 1 2014-04-11 02:17:39 0 0
2 2 2014-04-09 12:42:48 1 0
3 2 2014-04-10 12:44:14 0 0
3 2 2014-04-11 02:48:54 1 0
3 3 2014-04-09 12:43:23 0 0
3 3 2014-04-09 12:43:23 1 0
0 in log type is =login
1 in log type is =login
this will be the format
emp id IN OUT HOURS
2 6/2/2014 8:15 6/2/2014 17:00 7.25
2 6/2/2014 8:15 6/2/2014 17:00 7.25
thanks for your help