摘要：通道里的车情况： 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 阅读全文