SELECT
*
FROM
( SELECT * FROM *table* WHERE *a* = #{*a*} AND *b*= #{*b*} ORDER BY c DESC )
WHERE
ROWNUM = 1
06-28
9118
07-30
4044
11-17
938
05-20
1107