sql语句选择id最大的一项

SELECT * FROM CountTable WHERE CountTable.id =(SELECT MAX(id) FROM CountTable WHERE CountTable.level1= 2)
UPDATE CountTable  SET CountTable.level2 =110  WHERE CountTable.id =(SELECT MAX(id) FROM CountTable WHERE CountTable.level1= 2)
原文地址:https://www.cnblogs.com/mathyk/p/9959764.html