UC知道请教个存储过程
来源：百度知道 编辑：UC知道 时间：2024/06/05 22:06:19
我取得数据库（order by time）后的第5，10，15，20，25条记录，请问这个存储过程怎么写。
建议你使用游标来取。这样有规律的取，还是游标来方便。
当然time是关键字不能做字段名,这个我写就这样写了,你应该看得明白的
select top 1 字段 from (select top 5 字段,time from 表 order by time asc) as m order by time desc ]
union
select top 1 字段 from (select top 10 字段,time from 表 order by time asc) as m order by time desc
union
select top 1 字段 from (select top 15 字段,time from 表 order by time asc) as m order by time desc
union
select top 1 字段 from (select top 20 字段,time from 表 order by time asc) as m order by time desc
union
select top 1 字段 from (select top 25 字段,time from 表 order by time asc) as m order by time desc