Excuse me,
How about the CROSS TAB, statistical factors all listed?
Classification of the EX students drop out of school a total of four types of health factors and economic factors studies the four other
, for these categories in the CROSS TAB set @ out_type
But actually the dropout statistics only to three of the four is, so will only shows three,
Could you tell me if statements to 4 are shown (because there was no information... 0), how should do??

(I think GOOGLE SQL available SQL Pivot but complex
Set for a long time can't success... )

CodePudding user response:

Suppose you health factors and economic factors in school, the other you only the first three, other need not, that is to say, only the first three data in the database, you can insert a other data in

Under your SQL with the union or union all select... 'other',... Insert a type artificial this way for other data, so cross statements will appear four types

CodePudding user response:

Thank you ~ zlf19810306
I later tried yesterday work
But because it is a statistical number, so there will be a number 1,
May be this pen data processing... If you don't show...
Export files I haven't tried export EXCEL never know whether information is not correct (more than one),