分页sql

SELECT * FROM (
        SELECT  ROW_NUMBER() OVER (ORDER BY a.employee_id) as RowNum,
                a.sn as sn,
                a.policy_no as policyNo,
                a.employee_id as sellerId
               
        FROM policy a,
             employee b
         WHERE 1=1
             and a.employee_id= b.employee_id
            
             )as temp_table
         WHERE 1=1
        
            and RowNum between 1
            and 10
           
           
           
           
        --SELECT count(*) FROM policy a inner join employee b on a.employee_id = b.employee_id