SQL ID问题
select distinct 1,'900',a.dsp,5,stuff (a.dsl,1,1,''),1 from jpftab b,jdstab a
where a.dd#=90000888 order by '900',5;

想让ID4从1，2，3这样按顺序下去

id1 id2 id3 id4id5 id6
19001001000355.0001
19001001000455.0001
19001001000555.0001
19001001000755.0001
19001001000955.0001

想要的结果

id1id2 id3 id4id5 id6
19001001000315.0001
19001001000425.0001
19001001000535.0001
19001001000745.0001
19001001000955.0001

[解决办法]

SQL code

--使用identity函数select distinct 1 as id1,'900' as id2,a.dsp as id3,id4 = IDENTITY(int, 1, 1),stuff (a.dsl,1,1,'') as id5,1  as id6into #tb from jpftab b,jdstab a  where a.dd#=90000888 order by id2,id4select id1,id2,id3,id4,id5,id6 from #tb