企业TOP10
上一个月企业TOP10
MySQL Query : SELECT info,money,yuan,choice_time,( SELECT count( DISTINCT money ) FROM cw_aixinbang AS b WHERE b.money > a.money and b.is_qy = 1 AND b.choice_time = 202403 ) + 1 AS Rank FROM cw_aixinbang a WHERE a.is_qy = 1 AND a.choice_time = 202403 ORDER BY money DESC LIMIT 20
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank FROM\x09cw_aixinbang a WHERE\x09a.is_qy = 1 \x09AND a.choice_time = 202403 ' at line 1
MySQL Errno : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank FROM\x09cw_aixinbang a WHERE\x09a.is_qy = 1 \x09AND a.choice_time = 202403 ' at line 1
Need Help?