select s.id, s.userid, s.shrdm,s.shrmc, s.zhfwtime from (select * from his_shr order by zhfwtime desc) s where rownum <= '10 ' and s.userid = 'K0000100001'
从数据库表中取出最后插入的几条数据的SQL语句。
最新推荐文章于 2021-01-07 10:30:11 发布
select s.id, s.userid, s.shrdm,s.shrmc, s.zhfwtime from (select * from his_shr order by zhfwtime desc) s where rownum <= '10 ' and s.userid = 'K0000100001'