php - MYSQL计算避免重复值

Question

我的 MySQL 表是

 htno     name       fathername       subcode      subject       internals     externals     total    result      tempcr
 12      Mahesh        Rajesh           256         Maths           20            55           75        P           1
 12      Mahesh        Rajesh           257        Science          18            60           78        P           1
 12      Mahesh        Rajesh           256         Maths           20            55           75        P           1
 12      Mahesh        Rajesh           257        Science          18            60           78        P           1

表格有重复行

我需要的输出是

HTNO     TOTAL MARKS SECURED       PERCENTAGE       TOTAL SUBJECTS       SUBJECTS ATTEMPTED      SUBJECTS ABSENT         SUBJECTS PASSED        BACKLOGS
12               153                   76.5%             2                      2                       0                    2                       0

我得到的输出是

HTNO     TOTAL MARKS SECURED       PERCENTAGE       TOTAL SUBJECTS       SUBJECTS ATTEMPTED      SUBJECTS ABSENT         SUBJECTS PASSED        BACKLOGS
12               306                   153%              4                      4                       0                    4                       0

这是实际计算的两倍

我想在此计算中排除那些重复的行

请给我一些提示

Answer 1

尝试

SELECT htno, 
       SUM(total)               tech, 
       ROUND(SUM(total) / 2, 2) divi, 
       SUM(tempcr)              cred, 
       SUM(tempcr <= 0)         log,
       SUM(tempcr >  0)         pass, 
       SUM(externals >= 0)      atm, 
       SUM(externals <  0)      tot
  FROM 
( 
  SELECT DISTINCT * 
    FROM Table1 
   WHERE htno = 12
) q

输出:

| HTNO | TECH | DIVI | CRED | LOG | PASS | ATM | TOT |------------------------------------------------------|   12 |  153 | 76.5 |    2 |   0 |    2 |   2 |   0 |

这是 SQLFiddle 演示