presto 分页:
select *
from (
select * ,row_number() over (order by prod_unique_machine_id) rn
from proj_cbi_test.Dm_machine_service_recommendation_na
)
where rn between 0 and 100
prod_unique_machine_id 这个字段为该表主键
presto 分页:
select *
from (
select * ,row_number() over (order by prod_unique_machine_id) rn
from proj_cbi_test.Dm_machine_service_recommendation_na
)
where rn between 0 and 100
prod_unique_machine_id 这个字段为该表主键