提问人:kompus 提问时间:11/10/2023 更新时间:11/10/2023 访问量:56
如何更改从 ROLLUP 创建的最后一行的文本
How to change text on the last row created from ROLLUP
问:
我创建了这个SQL查询:
SELECT
orders.order_id AS "Nr. zamówienia",
orders.order_date AS "Data zamówienia",
products.name AS "Nazwa produtku",
products.price AS "Cena produtku",
orders.count AS "Ilość",
clients.client_id AS "Numer klienta",
clients.first_name AS "Imię",
clients.last_name AS "Nazwisko",
SUM(orders.count * products.price) AS "Cena Łączna"
FROM orders
INNER JOIN clients ON orders.client_id = clients.client_id
INNER JOIN products ON orders.product_id = products.product_id
WHERE orders.client_id = 215234
GROUP BY orders.order_id WITH ROLLUP
并得到这个结果:resuult of query
是否可以将最后一行更改为仅在“Nazwisko”列中显示“Sum:”,而不显示加倍的最后一行?
答: 暂无答案
评论
_id