sql count if

SELECT COUNT(DISTINCT empid)
FROM your_table
WHERE odd_no = 123456 AND oper_no = 10

Select allOpen in new window

You'll want to look at the full data set just to make sure the above is correct, and any duplicate values are being handled

SELECT odd_no, oper_no, emp_id
FROM your_table
WHERE odd_no = 123456 AND oper_no = 10
ORDER BY odd_no, oper_no, emp_id

Select allOpen in new window

what if I want to look at all work orders and operations to see how many employees where clocked into the same one and not just one  exact work order?

Not entirely sure what you mean by 'the same one', but give this a whirl..

List...

SELECT odd_no, oper_no, emp_id
FROM your_table
ORDER BY odd_no, oper_no, emp_id

Select allOpen in new window

Count...

SELECT odd_no, oper_no, COUNT(emp_id) as empl_id_count
FROM your_table
GROUP BY odd_no, oper_no
ORDER BY odd_no, oper_no

Select allOpen in new window

Here is what i need to count

work order     operation number     employee number     count
12345                  10                                2321                           2
2468                      20                               1234                          2
12345                     10                               1234                         2
2468                       20                                2321                        2
13579                    10                                 2321                        1

This is kinda what I am looking for....

Nice mockup data.  Next time please add that to your original question, so we don't have to spend time flushing out requirements.

Based on the set above, give this a whirl, and add an ORDER BY clause to sort it by whatever is most readable..

SELECT 
   odd_no as work_order, 
   oper_no as operation_number, 
   emp_id as employee_number, 
   COUNT(emp_id) as empl_id_count
FROM your_table
GROUP BY odd_no, oper_no, emp_id

Select allOpen in new window