[ SQL璇彞 ] : SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT convert(varchar(255),NameStr) as NameStr,convert(varchar(255),Picture) as Picture,convert(varchar(255),ID) as ID,MemberPrice,MarketPrice,Points FROM w_product WHERE ( SubClassification = '31141106' ) AND ( State = 1 )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 5)
付费求助
联系QQ:401167775
最佳答案