how to filter in sql
Posted
by
user3634746
on Stack Overflow
See other posts from Stack Overflow
or by user3634746
Published on 2014-06-12T03:20:49Z
Indexed on
2014/06/12
3:24 UTC
Read the original article
Hit count: 67
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
© Stack Overflow or respective owner