mysql - 总结 MySQL 查询结果的问题

Question

以下查询返回附加图像中显示的内容。我认为很简单的事情结果变得非常复杂。我现在只想将结果汇总为一行和一列。在这种情况下，总和将是 161。我该怎么做？我真的尝试了一切。我希望我已经提供了足够的信息。

SELECT
TRUNCATE
    (
        SUM(
            `assignment`.`percentage_achieved` *(
            SELECT
                `unitComponentWeighting`.`percentage_weighting` / 100
            FROM
                `unitComponentWeighting`
            WHERE
                `assignment`.`assignment_component_id` = `unitComponentWeighting`.`component_lookup_id`
            LIMIT 1
        )
        ),
        2
    ) AS `unit_percentage_grade`
FROM
    `assignment`
LEFT JOIN `assignmentType` ON `assignment`.`assignment_type_id` = `assignmentType`.`id`
LEFT JOIN `assignmentComponentLookup` ON `assignmentComponentLookup`.`id` = `assignment`.`assignment_component_id`
LEFT JOIN `unit` ON `unit`.`id` = `assignment`.`unit_id`
LEFT JOIN `assignmentSequence` ON `assignmentSequence`.`id` = `assignment`.`assignment_sequence_id`
LEFT JOIN `yearGroup` ON `yearGroup`.`id` = `unit`.`year_group_id`
WHERE
    `yearGroup`.`id` = 1
GROUP BY
    `assignment`.`unit_id`

标签： mysql

Answer 1

尝试删除这部分“GROUP BY ” assignment。unit_id