SQL Server查询问题 [英] Sql server query problem

问题描述

我有一个SQL查询问题.我想从表中选择5条记录并将其分配为1，接下来的5条记录将其分配为2，接下来的5条记录将其分配为3，依此类推...

我该怎么做.


谢谢.

Hi,

I have problem with an SQL query. I want to select five records from a table and assign it 1 and the next 5 records assign it 2 and next 5 records assign it 3, etc...

How could I accomplish this.


Thanks.

推荐答案

UPDATE Table SET record = ( (id-1)/5+1 )

你的意思是那样吗?
它将[1,5]分配为1，[6,10]分配为2，依此类推.

Did you mean something like that?
It assigns [1,5] to 1, [6,10] to 2, etc.

这篇关于SQL Server查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！