对mysql 查询结果排序

SELECT A.*,@rank:=@rank+1 AS pm 

FROM
(
SELECT cptype FROM cp_base ORDER BY cptype DESC
) A ,(SELECT @rank:=0) B