查询test表中id为16的记录是第几行的两个方法 MySQL mysql select count(*) from test where id = (select id from test where id=16); +----------+| count(*) |+----------+| 1 |+----------+1 row in set (0.00 sec) mysql select count(*) from test wher
查询test表中id为16的记录是第几行的两个方法 MySQLmysql> select count(*) from test where id <= (select id from test where id=16); +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.00 sec)
mysql> select count(*) from test where id <= 16; +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.00 sec)
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。
