select row_number() over() as rownum,* from tbl3 order by ts desc limit 100;
上面这条语句的rownum从1开始生成
select row_number() over() as rownum,* from tbl3 order by ts desc limit 10;
而这条语句的rownum则是直接从表tbl3里取出来的。