MySQL查询某个记录行号

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

mysql> select count(*)  from test  where id <= (select id from test  where id=16); 
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.00 sec)