You can use temp table with IDENTITY column to achive that.
CREATE TABLE #temp (
idnum int IDENTITY,
type char(1) NULL,
counter int NOT NULL)
INSERT INTO #temp (type, counter)
select Type,
count('x') as Counter
from Client
group by Type
ORDER BY 1
SELECT * FROM #temp
DROP TABLE #temp
>Hi!
>
>I would like to know how to add an incremental value as a Column in a Query.
>
>e.g.:
>Table: Client.
>Code Name Type
>112533 John A
>421326 Samuel B
>721423 Peter A
>443231 Steve A
>551242 Erick C
>632142 Mariah B
>242312 Carlos B
>
>select
as IdNum,
> Type,
> count('x') as Counter
>from Client
>group by Type
>
>
>Result:
>IdNum Type Counter
>1 A 3
>2 B 3
>3 C 1
>Thanks in advance!
--sb--