拼接sql条件时，怎样体现某个属性值最大呢？

Question

现有一个sql语句：select * from mytable where status = 'Prepare' and desc的值最大。这个怎么sql语句怎么书写呢？

Answer 1

select * from mytable where status = 'Prepare' and desc = (select max(desc) from mytable);