ORDER BY and COMPUTE clauses to define the order of the final results or compute summary values are allowed only at the end of the UNION statement. They cannot be used within the individual queries that make up the UNION statement.
select ID, 类别,时间,属性 from 表 where 属性>=1 and 属性<=5 order by 时间,类别
union all
select ID, 类别,时间,属性 from 表 where 属性=0 order by 类别,时间
union all
select ID, 类别,时间,属性 from 表 where 属性<>0 and (属性<1 or 属性>5)order by 类别,时间