select top 6 * from A where id not in(select top 4 id from A)
select top 6 * from A where id not in (select top 4 id from A order by id) order by id
select id=identity(int,1,1),* into #temp from Aselect * from #temp where id>4 and id<11drop table #temp
CREATE TABLE TAB (ID BIGINT,DEVICEID NVARCHAR(15),ATTACKTYPE NVARCHAR(50))DECLARE @AIIDX BIGINT,@DEVICEID NVARCHAR(15),@ATTACKTYPE NVARCHAR(50) DECLARE @I INT SET @I=1 DECLARE MY_CURSOR CURSOR FOR SELECT AIIDX,DEVICEID,ATTACKTYPE FROM AI OPEN MY_CURSOR FETCH NEXT FROM MY_CURSOR INTO @AIIDX,@DEVICEID,@ATTACKTYPE WHILE @@FETCH_STATUS=0 BEGIN SET @I=@I+1 IF (@I>5) AND (@I<=10) INSERT INTO TAB(ID,DEVICEID,ATTACKTYPE) VALUES(@AIIDX,@DEVICEID,@ATTACKTYPE) FETCH NEXT FROM MY_CURSOR INTO @AIIDX,@DEVICEID,@ATTACKTYPE END CLOSE MY_CURSOR DEALLOCATE MY_CURSOR SELECT * FROM TAB DROP TABLE TAB
DECLARE @I INT
SET @I=1
DECLARE MY_CURSOR CURSOR FOR
SELECT AIIDX,DEVICEID,ATTACKTYPE FROM AI
OPEN MY_CURSOR
FETCH NEXT FROM MY_CURSOR INTO @AIIDX,@DEVICEID,@ATTACKTYPE
WHILE @@FETCH_STATUS=0
BEGIN
SET @I=@I+1
IF (@I>5) AND (@I<=10)
INSERT INTO TAB(ID,DEVICEID,ATTACKTYPE) VALUES(@AIIDX,@DEVICEID,@ATTACKTYPE)
FETCH NEXT FROM MY_CURSOR INTO @AIIDX,@DEVICEID,@ATTACKTYPE
END
CLOSE MY_CURSOR
DEALLOCATE MY_CURSOR
SELECT * FROM TAB
DROP TABLE TAB