SELECT
*
FROM
( SELECT * FROM *table* WHERE *a* = #{*a*} AND *b*= #{*b*} ORDER BY c DESC )
WHERE
ROWNUM = 1
oracle查询某个条件最新的一条数据
最新推荐文章于 2024-05-20 19:58:20 发布
SELECT
*
FROM
( SELECT * FROM *table* WHERE *a* = #{*a*} AND *b*= #{*b*} ORDER BY c DESC )
WHERE
ROWNUM = 1