select 星 from(
select (@rownum :=@rownum +1) as ‘row num’ ,t.星
from
(select * from 表
where where
order by time desc
)t,
(select @rownum:=0)m
)ts
select 星 from(
select (@rownum :=@rownum +1) as ‘row num’ ,t.星
from
(select * from 表
where where
order by time desc
)t,
(select @rownum:=0)m
)ts