随笔分类 -  Structured Query Language

SQL语句
取最小未用的账号
摘要：SELECT NVL(Min(t1.Accnum), 0) + 1 INTO newAccnum FROM T1 t1 WHERE (t1.accnum + 1) NOT IN (SELECT t2.accnum FROM T2 t2) AND t1.accnum > 0 AND EXISTS (S 阅读全文
posted @ 2016-05-03 13:52 珠烁晶莹 阅读(162) 评论(0) 推荐(0)