那在sql server中该怎么写才能达到mysql中的分组效果呢,分出的结果不一样
程序员文章站
2022-05-08 09:02:27
...
mysqlsql server
SELECT CASE WHEN AGE 10 AND AGE 20 AND AGE 30 AND AGE 40 AND AGE 50 AND AGE 60 AND AGE 70 AND AGE 80 AND AGE 90 AND AGE 100 THEN 'b' END allshuju ,COUNT(*) renshu,OUT_MAIN_DIAG_RST leibie FROM WORK_BASY_DATA where 1=1 and OUT_DT >= '2012-10-1' and OUT_DT