SQL获取最大ID语句

SELECT (CASE WHEN EXISTS(SELECT * FROM plate b WHERE b.p_ID = 1) THEN MIN(p_ID) + 1 ELSE 1 END) as ID 

FROM plate 

WHERE NOT p_ID IN (SELECT a.p_ID -1 FROM plate a)