这个语句怎么出现"未指定的错误啊!" ( 积分: 100 )

K

kjhwxm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #1

select ZW,SUM(CASE xb When '男' Then 1 Else 0 End),SUM(CASE xb When '女' Then 1 Else 0 End) from js group by ZW

大家帮我看看上面的语句:怎么出现"未指定的错误啊!"

 

X

xl4772

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #2

你要统计男生，女生数吗？

select ZW,sum(xb)
from (select zw,CASE xb When '男' Then 1 when '女' Then 0 end from js)
group by ZW

 

W

woshisunyi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #3

楼主的语句没有问题

 

K

kjhwxm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #4

To xl4772
用你上面的语句出现 Illegal character in input file:'男'
To woshisunyi 我的语句执行的时候出现:未指定的错误,编译通过
用的 是DELPHI7和ACCESS2000
全部语句是这样的:
with adoquery2 do begin
close;
sql.clear;
sql.add('select ZW,SUM(CASE xb When ''+男+'' Then 1 Else 0 End),SUM(CASE xb When ''+女+'' Then 1 Else 0 End) from js group by ZW');
open;

 

Y

ysai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #5

access 没有 case 用iif函数
sum(iif(xb='男', 1, 0))

 

L

laiaseven

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #6

这语句这样单独使用是没错误的,
当这语句作为子查询时就出现错误

 

K

kjhwxm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #7

To ysai
谢谢!按照你说的,经过修改,
with adoquery2 do begin
close;
sql.clear;
sql.add('select ZW,sum(iif(xb='男', 1, 0)),sum(iif(xb='女',1,0) from js group by ZW');
open;
出现 {Illegal character in input file:'男'} 错误!

 

K

kjhwxm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #8

好了,谢谢大哥!

 

K

kjhwxm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-30

• #9

多人接受答案了。