with temp1 as(
select * from table limit 10
)，
temp2 as(
select * from temp1 limit 5
)
Select * from temp2