SQL排序问题(40分)

A

amakusa

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-24

• #1

有三个整数字段 ABC 如何按A+B+C的值 排序

 

J

Jetshot

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-24

• #2

建立一个视图
select a,b,c,(a+b+c) as sumabc from tablename order by sumabc ASC/DESC

 

J

jrq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-24

• #3

楼上说了～

 

Z

zxb200

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-24

• #4

1.升序：select * from tablename order by (a+b+c)
1.降序：select * from tablename order by (a+b+c) desc

 

A

amakusa

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-26

• #5

多人接受答案了。