MYSQLmysql 查询多条a表信息，date字段等于2025，并且a表s字段在a表有多少条信息
mysql 查询多条a表信息，date字段等于2025，并且a表s字段在a表有多少条信息SELECT distinct y1.`s`,(SELECT COUNT(*) FROM a y2 WHERE y2.b = y1.b and date="2025-07-17" and y2.s = y1.s) AS s_count FROM a y1 where date = "2025-07-17" and s="内容";distinct y1.`s`去重表1s字段C...继续阅读 >>
