mysql没有类似 row_number()、over()等函数,所以使用@变量自增来绑定行号,再通过条件获取行号: select * from (select @row_num := @row_num+1,a.id from table_a a where CONDITIONS…,(select @row_num := 0) b) c where c.id = 123
mysql没有类似 row_number()、over()等函数,所以使用@变量自增来绑定行号,再通过条件获取行号:select * from (select @row_num := @row_num+1,a.id from table_a a where CONDITIONS…,(select @row_num := 0) b) c where c.id = 123...