一点即可得分 (^=^)(40分)

Z

zhbj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-02-09

• #1

语句 Select count(ID) as 数量, DW
From (select B.id,B.dw,B.SL,K.id
from B,K
where (B.ID = K.id) and (K.SL>20))
Group DW
如何执行错误！

 

L

liu_liu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-02-09

• #2

Select count(ID) as 数量, DW
From (select B.id,B.dw
from B,K
where (B.ID = K.id) and (K.SL>20))
Group DW

 

C

citybug

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-02-09

• #3

既然为B.ID=K.ID为何还要(select K.id)?

 

B

BaKuBaKu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-02-10

• #4

Group By DW
另外，子查询中的 ID 重复，最好分别开：From (select B.id,B.dw,B.SL,K.id As K_id

 

车

车超

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-02-12

• #5

一定是Group By DW 出错，你组合的条件不合理，建议先组合条件合理的字段，
然后再作一个循环对每个记录进行修改，我以前就是这么做的。

 

W

wjiachun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-14

• #6

多人接受答案了。