Morning Guys,
I have the following tables:
operator(ope_id, ope_name)
ope_shift(ope_id, shift_id, shift_date)
shift(shift_id, shift_start, shift_end)
here is a better view of the data
http://latinunit.net/emp_shift.txt
here is the screenshot of a select statement to the tables
http://img256.imageshack.us/img256/4013/opeshift.jpg
im using this code
SELECT OPE_ID, COUNT(OPE_ID) AS Total_shifts
from operator_shift
group by ope_id;
to view the current total shifts per operator and it works, BUT if there was 500 more rows it would count them all aswell, THE QUESTION is, anyone has a better way of making my database work, or how can i tell the system that those rows are a whole month, i remember i friend said something about count then devide by 30 but im not sure, what if the month isnt finished? and you want to show the emp with highest shifts to date