SELECT item_type_id, COUNT( * ) AS typeCount FROM prosper_item_base_info WHERE item_id IN ( '1116704448291274752', '1116704567245930496', '1116704728433033216', '1116704644853137408', '1116704823471767552', '1116704898314928128', '1116705032100642816', '1116704823471767552', '1116704898314928128' ) ORDER BY typeCount DESC 如何让他的返回的结果typeCount数量为9
时间: 2023-09-28 18:03:51 浏览: 27
要让返回的结果 `typeCount` 数量为 9,你可以将 `LIMIT` 子句中的数字改为 9,如下所示:
```
SELECT item_type_id, COUNT(*) AS typeCount
FROM prosper_item_base_info
WHERE item_id IN ('1116704448291274752', '1116704567245930496', '1116704728433033216', '1116704644853137408', '1116704823471767552', '1116704898314928128', '1116705032100642816', '1116704823471767552', '1116704898314928128')
GROUP BY item_type_id
ORDER BY typeCount DESC
LIMIT 9
```
这样就可以限制结果数量为 9。需要注意的是,如果数据中存在相同的 `typeCount` 数量,那么可能会返回多于 9 行的结果。同时,为了正确统计每种 `item_type_id` 的数量,我在查询语句中添加了 `GROUP BY` 子句。
相关问题
SELECT item_type_id, COUNT(item_type_id ) AS typeCount, FROM prosper_item_base_info WHERE item_id IN ( '1116704448291274752', '1116704567245930496', '1116704728433033216', '1116704644853137408', '1116704823471767552', '1116704898314928128', '1116705032100642816', '1116704823471767552', '1116704898314928128' ) GROUP BY item_type_id ORDER BY typeCount DESC LIMIT 10哪里出错了
在这个 SQL 查询语句中,有一个多余的逗号,它在 COUNT(item_type_id ) AS typeCount, 语句中出现,应该将它删除。同时,在这个查询语句中,item_id IN (...) 子句中出现了重复的 item_id 值,需要将其去重。以下是修改后的 SQL 查询语句:
```
SELECT item_type_id, COUNT(item_type_id) AS typeCount
FROM prosper_item_base_info
WHERE item_id IN ('1116704448291274752', '1116704567245930496', '1116704728433033216', '1116704644853137408', '1116704823471767552', '1116704898314928128', '1116705032100642816')
GROUP BY item_type_id
ORDER BY typeCount DESC
LIMIT 10
```
SELECT item_type_id, COUNT( * ) AS typeCount FROM prosper_item_base_info WHERE item_id IN ( '1116704448291274752', '1116704567245930496', '1116704728433033216', '1116704644853137408', '1116704823471767552', '1116704898314928128', '1116705032100642816', '1116704823471767552', '1116704898314928128' ) ORDER BY typeCount DESC LIMIT 10 如何让他的返回的结果typeCount数量为9
要让返回的结果 `typeCount` 数量为 9,你可以将 `LIMIT` 子句中的数字改为 9,如下所示:
```
SELECT item_type_id, COUNT( * ) AS typeCount
FROM prosper_item_base_info
WHERE item_id IN ( '1116704448291274752', '1116704567245930496', '1116704728433033216', '1116704644853137408', '1116704823471767552', '1116704898314928128', '1116705032100642816', '1116704823471767552', '1116704898314928128' )
ORDER BY typeCount DESC
LIMIT 9
```
这样就可以限制结果数量为 9。需要注意的是,如果数据中存在相同的 `typeCount` 数量,那么可能会返回多于 9 行的结果。