DECLARE @mid INT= 429;
DECLARE @mi_phone VARCHAR(50)= '18505959580';
--第一种
SELECT  *
FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY mi.mi_id DESC ) row ,
                    mi.mi_id ,
                    mi_name
          FROM      m_memberinfo mi
          WHERE     mi.mid = @mid
                    AND mi_phone = @mi_phone
        ) Tbl
WHERE   row BETWEEN 1 AND 15;
--第二种
SELECT  *
FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY mi.mi_id DESC ) row ,
                    mi.mi_id ,
                    mi_name
          FROM      m_memberinfo mi
          WHERE     mi.mid = @mid
                    AND mi_phone = '18505959580'
        ) Tbl
WHERE   row BETWEEN 1 AND 15;