请关注。在线等待，关于SQL语句,50分，急 (50分)

M

maliang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-05

• #21

SQL.Add('(select count(b.sex) from tyqkb.db As b where b.sex="男") As 男职员');
编译器提示是：invalid use of keyword
token select line number:3,
是怎么回儿事，请大家帮助解决一下

 

H

HeyTommy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-05

• #22

你把 “男职员” 换成英文的试试？？？

 

M

maliang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-05

• #23

HEYTOMMY，THANK YOU。把 “男职员” 换成英文也不行，不是中英文的事儿，
是复合语句的事儿。我就是不知该怎么写。请大家帮帮忙。

 

J

jesse.zhou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-13

• #24

在SQL Server中:
SELECT a.dept AS 部門, COUNT(a.name) AS 職員數,
(SELECT COUNT(b.sex)
FROM worker b
WHERE b.dept = a.dept AND b.sex = '男') AS 男職員數,
(SELECT COUNT(b.sex)
FROM worker b
WHERE b.dept = a.dept AND b.sex = '女') AS 女職員數
FROM worker a
GROUP BY a.dept

 

B

blave

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #25

OK

 

B

blave

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #26

OK