请教access 的行转列问题 http://topic.csdn.net/u/20080401/11/3f2cf474-59fe-4348-b305-f260753ccd24.html?1580337680 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT ZLDWDM, max(iif( DLBM = '01' , TBMJ , 0) ) AS gd, max(iif( DLBM = '02' , TBMJ , 0) ) AS yd, max(iif( DLBM = '03' , TBMJ , 0) ) AS ldFROM tb2GROUP BY ZLDWDM; 就这个在MSSQL 中也通不过,因为from前多了一个 , access 中是用iif ,没有case when end的语法SELECT ZLDWDM, max(iif( DLBM = '01' , TBMJ , 0) ) AS gd, max(iif( DLBM = '02' , TBMJ , 0) ) AS yd, max(iif( DLBM = '03' , TBMJ , 0) ) AS ld FROM tb2 GROUP BY ZLDWDM; int自增类型字段需要再加索引吗? create view 问题 请教一句SQL语句 sql语法错误 要怎么修改 问题个简单而有趣的问题,不知各位有没有研究? 请问如何定时运行SSIS包? 从EXCEL中导入至SQL中的表是带$的,如何将此符号去掉,并且让它显示在企业管理器中? 【SQL】概率问题 我的SQL SERVER无法正常连接了,救命呀 初学者问题:PROC程序用什么来编译呢? SQL2000单表查询 按两项排序 求一条SQL语句。。。。不知道怎么写
max(iif( DLBM = '01' , TBMJ , 0) ) AS gd,
max(iif( DLBM = '02' , TBMJ , 0) ) AS yd,
max(iif( DLBM = '03' , TBMJ , 0) ) AS ld
FROM tb2
GROUP BY ZLDWDM;
max(iif( DLBM = '01' , TBMJ , 0) ) AS gd,
max(iif( DLBM = '02' , TBMJ , 0) ) AS yd,
max(iif( DLBM = '03' , TBMJ , 0) ) AS ld
FROM tb2
GROUP BY ZLDWDM;