我想使用表联结(UNION)建立一新记录“小计",方法如下： (100分)

P

PDF

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-03

• #1

我想使用表联结(UNION)建立一新记录“小计",方法如下：
SELECT DISTINCT P1,P2,P3,..
From Table1 Group by P1
Union
SELECT "","小计",SUM(P3)
FROM
(SELECT DISTINCT P1,P2,P3,..
From Table1 Group by P1)
一张表循环了两次，运行效率教低，各位大侠能否指点
一二，让我做的简单一点?

 

L

Lambert

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-03

• #2

SELECT DISTINCT P1,P2,P3,..
From Table1
Compute Sum(P3)

此方法在SQL中ISQL_w中调试通过,但在SQL Explorer中返回的结果....?

 

M

menxin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-03

• #3

呵呵，没什么好办法吧

 

W

wjiachun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-16

• #4

多人接受答案了。