摘要:
改成这样:to_date('2023-03-24','yyyy-MM-dd') select * from Tr_Bas_Part_Inventory_Details t where 1=1 and t.INVENTORY_TIME >= to_date('2023-03-24','yyyy-MM- 阅读全文
摘要:
通道里的车情况: SQL展示所有的车 SQL 再取出每个通道里的第一辆或最后一辆 row_number() over (partition by ROUTE_NUMBER_I order by ROUTE_INDEX_I asc) as t 注意要套一层select 和 where t = 1 阅读全文
摘要:
例子:在1,2,3,4,5中筛选不包含1,3,4,5的数字是 2 结果如截图 select ROUTE_NUMBER_I from (select 1 ROUTE_NUMBER_I from dual union all select 2 ROUTE_NUMBER_I from dual union 阅读全文