请告诉我如何更改查询，以便最终级别不重复行，即执行后有 8 行，而不是 30 行。例如，您可以写 distinct，但查询需要很长时间是时候处理大数据了。
with cte as
(select 1 as first_ticket_barcode
from dual
union all
select 5 as first_ticket_barcode
from dual
)
select first_ticket_barcode + level -1
from cte
connect by level <= 4