SELECT 姓名,峰值,00 名次 FROM aa ORDER BY 姓名 ,峰值 DESC INTO CURSOR BB READWRITE UPDATE BB SET 名次=(SELECT COUNT(*)+1 FROM BB B WHERE BB.峰值<B.峰值 AND BB.姓名=B.姓名) FROM BB BROWSE FOR 名次<=2
坚守VFP最后的阵地
以下是引用sdta在2012-10-12 14:59:36的发言：
SELECT 姓名,峰值,00 名次 FROM aa ORDER BY 姓名 ,峰值 DESC INTO CURSOR BB READWRITE
UPDATE BB SET 名次=(SELECT COUNT(*)+1 FROM BB B WHERE BB.峰值
方法多种SELECT 姓名,峰值,00 名次 FROM aa ORDER BY 姓名 ,峰值 DESC INTO CURSOR BB READWRITE
UPDATE BB SET 名次=(SELECT COUNT(*)+1 FROM BB B WHERE BB.峰值
版主这个就可以
我尝试直接select出来结果
没有成功
- 因为我不大会sql语句
SQL-SELECT(任明汉).rar
