如何在SQL查询中将select的结果用作偏移量

I was trying to create a single SQL query to return what I need, instead of creating 2 querys, but I need to use the result of one of the querys as the I was trying to create a single SQL query to re