仅用SQL不能。如果一定要在数据库中实现,则你可以先建一张表 tseq(id int primary key); 其中存储足够多的序列 1,2,3,4,5.....N;然后你可以select @X+(id-1)*@S as begin, @X+(id)*@S as end from tseq where @X+(id-1)*S<=@Y order by id
SET @s=0.5; SET @X=5.5; SET @Y=8; SELECT (@Y-@X)/@s; SELECT *,@X+(id-1)*0.5 AS beg ,@X+(id)*@S AS END FROM lsb1 WHERE id<=(@Y-@X)/@sLSB1:自增字段ID,1-10000
SET @X=5.5;
SET @Y=8;
SELECT (@Y-@X)/@s;
SELECT *,@X+(id-1)*0.5 AS beg ,@X+(id)*@S AS END
FROM lsb1 WHERE id<=(@Y-@X)/@sLSB1:自增字段ID,1-10000