Question

几天前,我遇到了一个问题,即我不得不在MySql &总结一些重复增长的价值;我曾尝试过一些问询,但确实没有工作。

下表数据:

card_id     tic_id  game_id     card_symbol     card_symbol_no  qty
1           6           1           C                   6        2
2           6           1           H                   7        6
3           6           1           C                   6        7

而且我期望的产出是:

card_id     tic_id  game_id     card_symbol     card_symbol_no  qty
1              6        1           C               6           (9)
2              6        1           H               7           (6)

some other given factor :-
1.) the "tic_id", & "game_id" is same.

Answer 1

select 
  min(card_id) as card_id, 
  tic_id, 
  game_id, 
  card_symbol, 
  card_symbol_no, 
  sum(qty) as qty
from 
  yourTabel
group by 
  tic_id, 
  game_id, 
  card_symbol, 
  card_symbol_no

友情链接