1.排序
--设置一个变量
--写法一:
set @rownum = 0;
select (@rownum :=@rownum + 1) as rn, t.* from table_name t
--写法二:
select (@rownum:=@rownum+1) as rn, t.* from table_name t,(select @rownum:=0) as a
2.去除重复
--加入关键字 DISTINCT
select DISTINCT t.* from table_name t;