The excuse me how the figure of a database table style, make the excel table display the query results,

CodePudding user response:

Using aggregate functions, Max, min, sum, and so on

CodePudding user response:

Select Max (case when a1="' then 0 else a1 end) as a1_1,... SCDH from t group by SCDH, if the sum is the sum