mysql - 如何在 MySQL 中获取 MAX 值?
问题描述
如何获取下表中每个专辑ID(45、12、22、8)的MAX值?我试过这个查询。但它返回了我的第一个值,而不是最大值。(3、6、5、6)
SELECT
*
FROM
(
SELECT
*
FROM
contentnew
WHERE
genreID = 1
ORDER BY
albumID DESC,
reg_count DESC
) AS newTB
GROUP BY
albumID;
看看这个
如果我使用
解决方案
你可以试试
select max(reg_count) from contentnew group by albumID
推荐阅读
- spring - 春天将字符串写入文件 - 间距错误
- c# - How to fix 'Unable to configure HTTPS endpoint. No server certificate was specified, and the default developer certificate could not be found.'
- python - scrapy 如何抓取随机文本或没有类和 id
- bash - .bashrc 文件正在循环“脚本”命令
- c# - FormsAuthentication Decrypt In Asp.Net Core
- bash - How can I update column values with the content of a file without interpreting it?
- python-3.x - How to extract Requests/Seconds (Throughput) of a performance test using Locust?
- jenkins - 是否可以在詹金斯管道的并行阶段运行相同的詹金斯构建作业
- python - Recursively searching both file and subfolder names for a list of strings
- laravel - 如何为我的 Laravel 应用程序创建私钥