oracle 中查找不连续的数的最前一个值
摘要:
select min(max(content_code))+ 1 sr_nofrom(select t.content_code, t.content_code - row_number() over(order by content_code) diff from epp_t_content t where content_code between 12290 and 12299)group by diff; 阅读全文
posted @ 2011-12-29 21:20 小山丘 阅读(381) 评论(0) 推荐(0) 编辑