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
浙公网安备 33010602011771号