SQL Server Group queries

CREATE TABLETest (IDint Primary Key  not NULL Identity, Namesvarchar( -));Declare @i int;Set @i=1; while(@i< +)begin    Insert  intoTestValues('T'+cast(@i  as varchar(8))); Select @i=@i+1;End--Method 1Select Top Ten * fromTestwhereId not inch( --40 is calculated as: 10* (5-1) Select Top  +Id fromTestOrder  byID)Order  byid--Method 2Select Top Ten * fromTestwhereId>( Select Max(ID) from   (   Select Top  +Id fromTestOrder  byID) A)Order  byid;--Method 3Select Top Ten * from ( SelectRow_number () Over(Order  byId asRowNumber*  fromtest) AwhereRowNumber>  +--Method 4Select * from ( SelectRow_number () Over(Order  byId asRowNumber*  fromtest) AwhereRowNumber>=  A  andRowNumber<=  -

SQL Server Group queries