Select count() max() Date
Posted
by DAVID
on Stack Overflow
See other posts from Stack Overflow
or by DAVID
Published on 2010-04-26T20:30:56Z
Indexed on
2010/04/27
2:23 UTC
Read the original article
Hit count: 377
I have a table with shifts history along with emp ids.
I'm using this query to retrieve a list of employees and their total shifts by specifying the range to count from:
SELECT ope_id, count(ope_id)
FROM operator_shift
WHERE ope_shift_date >=to_date( '01-MAR-10','dd-mon-yy') and ope_shift_date
<= to_date('31-MAR-10','dd-mon-yy')
GROUP BY OPE_ID
which gives
OPE_ID COUNT(OPE_ID)
1 14
2 7
3 6
4 6
5 2
6 5
7 2
8 1
9 2
10 4
10 rows selected.
How do I choose the employee with the highest number of shifts under the specified range date?
© Stack Overflow or respective owner