c 40 d 50 e 10 f 15 b 10 我怎么才能查到下面的结果?(把name 相同的查出来) name b 30 b 10
name a 10 b 30 c 40 d 50 b 10 我怎么才能查到下面的结果?(把name 相同的查出来) name b 30 b 10
select id, sum() from table_name group by id
select id,sum() from table_name group by idto shiyi54321: select a.name,a. from table1 a,table1 b where a.name=b.name group by b.name having count(*)>1
from tab
group by id
d 50
e 10
f 15
b 10
我怎么才能查到下面的结果?(把name 相同的查出来)
name
b 30
b 10
a 10
b 30
c 40
d 50
b 10
我怎么才能查到下面的结果?(把name 相同的查出来)
name
b 30
b 10
from table_name
group by id
select a.name,a. from table1 a,table1 b where a.name=b.name group by b.name having count(*)>1