对我来说，欧文想要实现的目标尚不清楚:

For me it is unclear what Irveen wants to achieve:

@Irveen，为什么不包含105条记录的表?每周您都会删除一条记录，并添加另一条记录.您将永远不会更改您的查询.

@Irveen, Why not a table with 105 records? Every week you drop one record and you add enother one. You will have never to change your query.

另一种解决方案是转移数据，因此您将第2列的数据放入1、3放入2、2、4放入3，...，103放入102.您将不必添加列或删除列.

Another solution is to shift your data, so you put the data of column 2 into 1, 3 into 2, 4 into 3, ..., 103 into 102. You will never have to add a column and drop a column.