我如何完成这样的查询:
SELECT type, COUNT(name) as cnt FROM products WHERE cnt > 1 GROUP BY type
该查询产生错误#1054 – ‘where子句’中的未知列’cnt’
这是因为WHERE在分组之前适用.
我该如何解决这个问题?
表结构:
id name type price
123451 Park's Great Hits Music 19.99
123452 Silly Puddy Toy 3.99
123453 Playstation Toy 89.95
123454 Men's T-Shirt Clothing 32.50
123455 Blouse Clothing 34.97
123456 Electronica 2002 Music 3.99
123457 Country Tunes Music 21.55
123458 Watermelon Food 8.73