随笔分类 -  SQL

SQL获取最大ID语句
摘要：SELECT (CASE WHEN EXISTS(SELECT * FROM plate b WHERE b.p_ID = 1) THEN MIN(p_ID) + 1 ELSE 1 END) as IDFROM plateWHERE NOT p_ID IN (SELECT a.p_ID -1 FROM plate a) 阅读全文
posted @ 2011-07-22 15:15 左轮death029 阅读(972) 评论(2) 推荐(1)