<br />select id,name,type,ROW_NUMBER() OVER(ORDER BY TYPE DESC) AS '级别' from levelinfoselect id,name,type,DENSE_RANK() OVER(ORDER BY TYPE DESC) AS '级别' from levelinfoselect id,name,type,RANK() OVER(ORDER BY TYPE DESC) AS '级别' from levelinfoselect id,