您可以只将select语句用作内联视图，而不需要#tmp表。

select t.id, name
from (select id, name, ROW_NUMBER() over (order by id) as srNo from Employee) t
where (t.srNo % 2) = 1

SqlFiddle函数

--从表中提取ALTERNATE记录（偶数）

Select * from TableName where ColumnName % 2 = 0

对于例如：从人力资源.员工中选择 *，其中业务实体ID % 2 = 0
--从表中提取ALTERNATE记录（奇数）

Select * from TableName where ColumnName % 2 = 1

对于例如：从人力资源.员工中选择 *，其中业务实体ID % 2 = 1

我将student作为表名。
这是我的答案-〉
1.对于偶数行号-
> SELECT id from (SELECT rowno, id from student) where mod(rowno,2)=1
1.对于奇数行-
> SELECT id from (SELECT rowno, id from student) where mod(rowno,2)=1个

同样也可以使用**having**子句实现;但是它增加了group by任务：

SELECT id, name
FROM (SELECT id, name, ROW_NUMBER()over(order by id) AS srNo FROM Employee) x
GROUP BY srNo, id, name
HAVING (srNo % 2) = 0

您可以只使用select语句作为内联视图，而不需要#tblCities表。

select tbl1.CityID,tbl1.CityName from (select ROW_NUMBER() over(order by CityID asc) as row_no,CityID,CityName from tblCities) as tbl1  where tbl1.row_no%2=1

declare  @t table
    (
        id int,
        name nvarchar(20)
    )
    insert into @t
    Select 1, 'abc'
    union all
    Select 2, 'pqr'
    union all
    Select 2, 'pqr'
    union all
    Select 3, 'xyz'
    union all
    Select 4, 'lmn'
    union all
    Select 5, 'efg'
    union all
    Select 2, 'efg'

    Select * from(
    Select *, row_number() over(order by id) as rnum from @t ) t where rnum % 2 <> 0

create table t (id bigint NOT NULL, input_1 boolean not null, data_gps timestamp(0) not null);

insert into t (id, input_1,data_gps) values 
  (1, false  , '2022-01-01 15:42:07'),
  (2, true   , '2022-01-02 15:42:07'),
  (3, true   , '2022-01-03  15:42:07'),
  (4, false   , '2022-01-04  15:42:07'),
  (5, true   , '2022-01-05  15:42:07'),
  (6, true   , '2022-01-06  15:42:07'),
  (7, true   , '2022-01-07  15:42:07'),
  (8, true   , '2022-01-08  15:42:07'),
  (9, false   , '2022-01-09  15:42:07'),
  (10 ,true   , '2022-01-10  15:42:07'),
  (11, true   , '2022-01-11  15:42:07'),
  (12, true   , '2022-01-12  15:42:07'),
  (13, false   , '2022-01-13  15:42:07'),
  (14, true   , '2022-01-14  15:42:07');

您将拥有

下面是将按值更改分组的查询

select input_1, min(data_gps) as mind, max(data_gps) as maxd
from (
select input_1, data_gps,
     row_number() over (order by data_gps) 
     - row_number() over (partition by input_1 order by data_gps) as grp
from t
) as tmp
group by input_1, grp
order by min(data_gps);

结果

演示https://dbfiddle.uk/6Ajy3H5O