Sql query calculating the mean

IDENTITY ( data_type [ , seed , increment ] )

Arguments

data_type --> Is the data type of the identity column. Valid data types for an identity column are any data types of the integer data type category (except for the bit data type), or decimal data type.

seed --> Is the value to be assigned to the first row in the table. Each subsequent row is assigned the next identity value, which is equal to the last IDENTITY value plus the increment value. If neither seed nor increment is specified, both default to 1.

increment --> Is the increment to add to the seed value for successive rows in the table.

#Temp_Mean is a temporary table while MeanTable is original table. Since I need to create autogenerated ID column thats why I need to use temporary table to hold the resultset.

Thanks.....

Quick question about the syntax.

1.can you explain the Identity function, and each of its parameters. there are three parameters you included (int, 1, 1)


2. you syntax #Temp_Mean. what does the "#"  mean? Temp_Mean is a table

I consider it for SQL Server

select ident = IDENTITY(int, 1, 1),Color, COUNT(*) as count, SUM(Value)/COUNT(*) as mean into #Temp_Mean
from MeanTable
group by Color

select * from #Temp_Mean

drop table #Temp_Mean

Thanks.....