首先,查找某字段的最大值
select max(weight) from apple;
7888
接着,根据最大值,查找其所在行
select * from apple where weight =7888;
或者,有一个更简单的方式:
select * from apple order by weight desc limit 1;
首先,查找某字段的最大值
select max(weight) from apple;
7888
接着,根据最大值,查找其所在行
select * from apple where weight =7888;
或者,有一个更简单的方式:
select * from apple order by weight desc limit 1;