txt?19000?n?Tabtxt?397119744@qq.com?,?
1?txtc:\temp\1.txt?2?txt6
SET?SAFETY?OFF
create?table?t1?free?(a?int,b?int,c?int,d?int,e?int,f?int)
append?from?c:\temp\1.txt?DELIMITED?WITH?BLANK
select?a?from?t1?union?all?select?b?from?t1?union?all?select?c?from?t1?union?all?select?d?from?t1?union?all?select?e?from?t1?union?all?select?f?from?t1?into?table?t2
select?count(a)?from?t2?into?array?a_array
select?a,count(a)?as?a_count,str(round(100*count(a)/a_array(1),2),6,2)+"%"?as?a_present?from?t2?group?by?a