这句SQL语句有错吗?为什么加上COUNT(id) as fbbc就会出错啊?
=SQLEXEC(lnHandle,"select id,rqi,qbc,fbc,COUNT(id) as fbbc,qlc+flc as ylc,qrs+frs as rs,qys+fys as ys from bcszl where (substring(rqi,6,2) = ?mo) and (substring(rqi,1,4) =?ye ) and (LTRIM(yxxl)=?yxx) order by rqi asc ","bcszl_temp" )
找到原因了。COUNT是横向统计,横向统计qbc和fbc的个数。请问怎么进行横向COUNT?
这句语句是没有问题的。但只适合竖向统计个数。我现在是想每行都统计出个数。
SQLä¸çcount()è¯å¥æ¯è®¡ç®è¡æ°çè¯å¥ï¼ä½æ ¹æ®æ¬å·å
çå
容ä¸åï¼ç¥æåºå«ã
1ãå建æµè¯è¡¨ãæå ¥æ°æ®ï¼
create table test2ãåä¸åçæµè¯ï¼ä¸»è¦æ¯é对å段ä¸å«ænullçæ
åµï¼ã
ï¼aï¼æµè¯è¯å¥
select count(*) from test;--ä¸åºåå段ï¼éå¯¹å ¨è¡¨ç»æï¼
ï¼bï¼æµè¯è¯å¥ï¼
ç»æï¼
ï¼cï¼æµè¯è¯å¥ï¼
ç»æï¼
ç»è®ºï¼å¯¹countä¸ä¸º*æè
åä¸ä¸å«ç©ºå¼çå段ï¼ç»æå°±æ¯ææçè¡æ°ï¼å¦ææä¸åå«ç©ºå¼ï¼ç»æå°±æ¯å»é¤äºç©ºè¡çé¨åçè¡æ°ã