p_test2.height 02 172 01 170 Time taken: 0.053 seconds, Fetched: 2 row(s)SELECT * FROM (SELECT *, ROW_NUMBER() OVER(partition by id orderJOIN (SELECT * FROM p_test2) t_2 ON t_2.id = t1.id AND t2
我有一个mysql查询,它将返回表中的所有细节以及I need max_row count,即在单个select查询中使用COUNT(*)而不使用交叉联接的表中的总行数。注意: MySQL版本是8的早期版本SELECT * FROM tablename ORDER BY column name DESC LIMIT 0,10;