mdsk.net
当前位置:首页 >> sql函数,sElECt Count(A.ABC) As sum From A lEFt... >>

sql函数,sElECt Count(A.ABC) As sum From A lEFt...

SELECT SUM ( t.iSum ) as sum FROM ( select count(A.abc) as iSum from A left join B on A.id=B.id where A.abc='1' group by A.abc ); 或者 select count(A.abc) as sum from A left join B on A.id=B.id where A.abc='1'

1在一个语句内写多条语句时,每个语句之间用 符号分隔。 (A), (B): (C)、 (D); [A] [B] [C] [D] 2 下面 是合法的变量名。 (A)X_yz (B)123abc (C)integer (D)X-Y [A] [B] [C] [D] 3下面 是不合法的整常数。 (A)100 (B)&...

网站首页 | 网站地图
All rights reserved Powered by www.mdsk.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com