如何对Interbase计算的合计值进行排序?(100分)

B

Byg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-29

• #1

如:
Select Field1,Sum(Field2) As Field2 from Table1 Group By
Field1 Order By Field2 (Asc or desc) 无效,
同样的语句在SQL Server中准确,在Interbase中无效
如何解决?

 

P

Pipi.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-29

• #2

order by 2
order by 2 asc
order by 2 desc

1、2、3表示输出列的第几列

 

C

CJ

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-29

• #3

order by 2 interbase 也能用？
你还是直接用个 GRID把输出结果从新排序的好

 

P

Pipi.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-03-01

• #4

order by 2 interbase 也能用!
我记得好象是。

 

沈

沈前卫

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-03-01

• #5

在Oracle8i 下

Select Field1,Sum(Field2) As Field2 from Table1 Group By
Field1 Order By Field2 (Asc or desc)

与

order by 2
order by 2 asc
order by 2 desc

都正确！！！

 

B

Byg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-03-01

• #6

thank you PiPi,确实可用.

100分给你,接受答案.