sqm_ TBL table
sqm_fytj
create table test as
SELECT
*
FROM
(
SELECT
CURDATE() || "" AS "balance_date",
t.belonging_user || "" AS "belonging_name",
sum(t.total_deal_valid) AS "total_deal_valid",
FORMAT(sum(t.code_profit), 2) AS "total_code_profit",
sum(t.code_material) AS "total_code_material"
FROM
sqm_tbl t
GROUP BY
belonging_user
) a
WHERE
a.total_code_profit != "-";
Is a data type error?
Please give me your advice!