- 查询最新一条数据:
select * from
(select * from 表名 where fd_yard='123' order times )
where ROWNUM = 1
- 查询数据数量count:
select count(*) from 表名
select * from
(select * from 表名 where fd_yard='123' order times )
where ROWNUM = 1
select count(*) from 表名