SqlServer根据某列来分组后,再依据另一列来排序,选取第一行,后再依据另一列进行筛选,之后再统计数量
摘要:
一开始我写的sql类似于 select COUNT(*) from (select max(inspect_date) as newest_inspect_date,conclusion from single_card where conclusion='合格' and…… group by in 阅读全文
posted @ 2021-09-15 16:24 J·Marcus 阅读(407) 评论(0) 推荐(0) 编辑