| |
|
|
| |
to: lurix
(30.09.2008 в 11:04)
|
| | ПРедположим есть таблица "tbl1"
id - Счетчик
dt - Данные
SELECT
(Select Sum(1)
From tbl1 t
Where t.id <= t1.id) AS [N] ,
t1.id as [Код],
t1.dt as [Данные]
FROM tbl1 as t1
ORDER BY t1.id
|
Можно примерно так же, но с Count вместо SUM | |
| |
|
