现有一个sql语句:select * from mytable where status = 'Prepare' and desc的值最大。这个怎么sql语句怎么书写呢?
select * from mytable where status = 'Prepare' and desc = (select max(desc) from mytable);