用Query怎么知道比如有个Boolean的字段为true的有多少项呢？(50分)

N

netmax

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #1

用Query怎么知道比如有个Boolean的字段为true的有多少项呢？

 

Y

yobdrow

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #2

select count(boolfield) from 表 where boolfield=1

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #3

select count(boolfield) from 表 where boolfield

 

I

iapollo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #4

sql:='select count(*) from 表 where boolfield=true';

 

K

kasee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #5

select count(boolfield) from 表 where boolfield=true
呵呵！