摘要： select member.membername 姓名, hh.cardnumber 卡号, member.idcardnumber 电话, hh.points 积分 from (SELECT pointcard.cardnumber, pointcard.memberid, pointcard.totpoints, pointcard.points, sign(CUME_DIST() OVER(ORDER BY totpoints DESC) - 0.1) s1 FROM pointcard) hh, memberwhere hh.memberid = member.memberid and 阅读全文