瀚高数据库限制查询条数
原ORACLE语句:
select * from (select BEGINDATE,BEGINTIME from uf_PROJECT_CTMAIN where ennmcd=7632 and INSPECT_TYPE = '巡查'
and ceil((To_date(endtime , 'hh24-mi-ss') - To_date(begintime , 'hh24-mi-ss')) * 24 * 60 )>=5
order by BEGINDATE desc, BEGINTIME des
原创
2021-03-20 09:53:01 ·
443 阅读 ·
1 评论