sql server programming: Try,

create table t1 (
c1 int not null
)
go

insert into t1 values(1)
insert into t1 values(2)
insert into t1 values(3)
insert into t1 values(4)
insert into t1 values(5)
go

select
max(case when (c1 % 3) = 1 then c1 else null end) as c1,
max(case when (c1 % 3) = 2 then c1 else null end) as c2,
max(case when (c1 % 3) = 0 then c1 else null end) as c3
from
t1
group by
(c1 - 1) / 3

go

drop table t1
go


AMB


[quoted text, click to view]