主页 / dba / 问题 / 54159
Accepted
Uchsun
Asked: 2013-11-29 23:11:56 +0800 CST

在 Mysql 上查询结果不完美？

  • 772

我有这样的桌子

 ID | City     | Prize
_______________________
  1 | Surabaya | Notebook
  2 | Surabaya | Notebook
  3 | Surabaya | 
  4 | Bandung  | NoteBook
  5 | Bandung  | PC
  6 | Bandung  | Handphone
  7 | Bandung  |

我想按城市、奖品和数量对我的桌子进行分组，如下所示：

 ID | City     | Prize    | QTy
______________________________
  1 | Surabaya | Notebook  | 2
  2 | Bandung  | Handphone | 1
  3 | Bandung  | NoteBook  | 1
  4 | Bandung  | PC        | 1

我尝试这个查询但不完美这个我的查询

SELECT City, prize, count( prize ) AS qty
FROM `my_table`
GROUP BY hadiah

谁能帮我解决这个问题？

我非常感谢你的回答。

谢谢

我试过来自 JoeTaras 的查询

SELECT Kota, hadiah, count( hadiah ) AS qty
FROM unik
WHERE hadiah IS NOT NULL
GROUP BY kota, hadiah

结果仍然不正确，Null Value 也是 Count 在此处输入图像描述

mysql

1 个回答

  1. Best Answer

    尝试这个：

    SELECT City, prize, count( prize ) AS qty
FROM `my_table`
WHERE prize IS NOT NULL
GROUP BY city, prize
ORDER BY count(prize) DESC
    • 5

相关问题