摘要： xpsql=“用户名 like '王%'”;sql = string.Format(@"SELECT {0} FROM (SELECT row_number() over ( ORDER BY {1} ) as keelid,{0} FROM {2} {3} ) AS KeelTemp WHERE KeelTemp.keelid >={4} AND KeelTemp.keelid <={4}+{5}" , "用户ID,用户名,密码,电子邮件", "用户ID" , "[用户表]", xps 阅读全文