1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
CREATE TABLE #T
(id INT NOT NULL IDENTITY(1,1),
A VARCHAR(8),
B VARCHAR(8)
)
INSERT INTO #T VALUES('a1','b1')
INSERT INTO #T VALUES('a2','b2')
INSERT INTO #T VALUES('a3','b3')
INSERT INTO #T VALUES('a4','b4')
INSERT INTO #T VALUES('a5','b5')
INSERT INTO #T VALUES('a6','b6')
INSERT INTO #T VALUES('a7','b7')
INSERT INTO #T VALUES('a8','b8')
INSERT INTO #T VALUES('a9','b9')
INSERT INTO #T VALUES('a10','b10')
INSERT INTO #T VALUES('a11','b11')
SELECT
id, A, B,
CASE WHEN (id % 5) = 0
THEN ((id / 5))
ELSE ((id / 5) + 1)
END
from
#T |
Partager