select
form Table T
where
not in (
select
sicCd
form
Table
fetch first 100 rows only
) fetch first 100 rows only
思路:选取第一百到第二百条就是选取除了开头100 条以外的连续一百条,
select
form Table T
where
not in (
select
sicCd
form
Table
fetch first 100 rows only
) fetch first 100 rows only
思路:选取第一百到第二百条就是选取除了开头100 条以外的连续一百条,