Visualfoxpro60

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