Select 语句求解(100分)

M

mr.zy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-07-27

• #1

Select 语句求解

表.K
A B C D
1 2 3 4
1 2 3 4
2 3 4 5
2 3 4 5

将表K字段A、B相同字段C、D分别相加
如结果:
A B C D
1 2 6 8
2 3 8 10

Select语句有个函数可以把指定相同字段重复的记录筛选出来的,不知道是什么?谢谢!

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-07-27

• #2

select a,b,sum(c),sum(d)
from tablename
group by a,b
select * from
(select a,b,c,d from tablename having count(*)>1 group by a,b,c,d)

 

K

kkyy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-07-27

• #3

SELECT a, b, SUM(c) AS c, SUM(d) AS d
FROM K
GROUP BY a, b

 

M

mr.zy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-07-27

• #4

试试
送50分
谢谢

 

H

hgood

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-07-27

• #5

Select语句有个函数可以把指定相同字段重复的记录筛选出来的m不知道是什么?谢谢!
是﹕
select distinct
如 select distinct au_lname,au_id from authors