那在sqlserver中该怎么写才能达到mysql中的分组效果呢,分出的结果不一样
来源:懂视网
责编:小采
时间:2020-11-09 16:54:13
那在sqlserver中该怎么写才能达到mysql中的分组效果呢,分出的结果不一样
那在sqlserver中该怎么写才能达到mysql中的分组效果呢,分出的结果不一样: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 wher
导读那在sqlserver中该怎么写才能达到mysql中的分组效果呢,分出的结果不一样: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 wher
mysqlsql server
SELECT CASE WHEN AGE <= 10 THEN '1' WHEN AGE > 10 AND AGE <= 20 THEN '2' WHEN AGE > 20 AND AGE <= 30 THEN '3' WHEN AGE > 30 AND AGE <= 40 THEN '4' WHEN AGE > 40 AND AGE <= 50 THEN '5' WHEN AGE > 50 AND AGE <= 60 THEN '6' WHEN AGE > 60 AND AGE <= 70 THEN '7' WHEN AGE > 70 AND AGE <= 80 THEN '8' WHEN AGE > 80 AND AGE <= 90 THEN '9' WHEN AGE > 90 AND AGE <= 100 THEN 'a' WHEN 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 <= '2012-10-31' GROUP BY allshuju,OUT_MAIN_DIAG_RST having OUT_MAIN_DIAG_RST!='' AND allshuju!=''
声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
那在sqlserver中该怎么写才能达到mysql中的分组效果呢,分出的结果不一样
那在sqlserver中该怎么写才能达到mysql中的分组效果呢,分出的结果不一样: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 wher