SELECT

    id,

    name,

    staffopenid,

    imageurl,

    content,

    ordernum,

    praisenum,

    createdate,

    lable,

    label2,

    manageno

FROM

    (

        SELECT

            row_number()over(ORDER BY tempcolumn)temprownumber,

            *

        FROM

            (

                SELECT

                    top 开始位置+页面大小 tempcolumn=0,

                    *

                FROM

                    staffHairDesignerInfo)t )tt

WHERE

    temprownumber>开始位置

--开始位置：(页数-1)*页面大小