如何在单个sql查询中选择和求和

Question

Is it possible or another solution to sum and select multiple rows in single sql query and print with while looping like that:

$query = mysql_query("SELECT SUM(Total), * FROM table");
while ($fetch = mysql_fetch_row($query)) {
    echo $fetch[a];
    echo $fetch[b];
    echo $fetch[c];
}

Answer 1

Do you mean this?

SELECT (SELECT SUM(Total) FROM `table`) totalSum, a.* FROM `table` a