select a, b, to_char(round(a*100/b, 2)) || '%' as cfrom table_nameorder by (a/b); 转载于:https://www.cnblogs.com/xkoko/p/9377553.html