My sql数据库查询总条数，去除重复数据的总条数

最新推荐文章于 2024-08-13 17:15:48 发布

共度良宵夜

最新推荐文章于 2024-08-13 17:15:48 发布

阅读量2.4k

点赞数 1

文章标签： my sql 总记录数

本文链接：https://blog.csdn.net/XIA_1997/article/details/82142136

版权


SELECT d.*/*查询出download_qx d 所有字段*/,COUNT(*) COUNT,f.name/*upload_file f中原名*/ fileName/*此表新名*/,f.state fileState,f.qx fileQx 
FROM download_qx d 
LEFT JOIN upload_file f
ON d.fileId=f.fileId/*相同关联字段*/
WHERE 1=1		
GROUP BY d.userName,f.fileId


SELECT COUNT(*) FROM (

SELECT d.*/*查询出download_qx d 所有字段*/,COUNT(*) COUNT,f.name/*upload_file f中原名*/ fileName/*此表新名*/,f.state fileState,f.qx fileQx 
FROM download_qx d 
LEFT JOIN upload_file f
ON d.fileId=f.fileId/*相同关联字段*/
WHERE 1=1		
GROUP BY d.userName,f.fileId

) tmp



SELECT DISTINCT fileId/*字段*/ FROM download_qx/*表明*/ /*去重查询*/