Re: [程式] 計算人數
:
: --
: ※ 發信站: 批踢踢實業坊(ptt.cc)
: ◆ From: 219.71.211.104
: 推 bugle:select count(distinct id, id_birth) 05/30 13:07
: → zacaria:我用過上面這個 但是distinct用兩個欄位跑會出錯 05/30 15:24
: → zacaria:所以就不知道該怎麼辦了... 05/30 15:24
回文好像比較完整
先謝謝bugle的熱心
不過我用distinct條件設id, id_birth就會出現以下錯誤
程式碼:
proc sql;
create table b as
select count(distinct id, id_birth) from a;
quit;
錯誤訊息:
select count(distinct id, id_birth) from a;
-
22
76
ERROR 22-322: Syntax error, expecting one of the following:
!, !!, &, (, ), *, **, +, -, '.', /, <, <=, <>, =, >, >=,
?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS,
LE, LET, LIKE, LT, LTT, NE, NET, NOT,NOTIN, OR, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
但是只用select count(distinct id) from a
就很正常
想問是哪裡有錯呢?
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 219.71.211.104
推
05/30 20:01, , 1F
05/30 20:01, 1F
→
05/30 20:02, , 2F
05/30 20:02, 2F
→
05/30 20:02, , 3F
05/30 20:02, 3F
→
05/30 20:03, , 4F
05/30 20:03, 4F
→
05/31 09:08, , 5F
05/31 09:08, 5F
→
05/31 09:28, , 6F
05/31 09:28, 6F
→
05/31 09:28, , 7F
05/31 09:28, 7F
推
05/31 12:50, , 8F
05/31 12:50, 8F
推
05/31 14:14, , 9F
05/31 14:14, 9F
→
05/31 20:33, , 10F
05/31 20:33, 10F
討論串 (同標題文章)