sql(10分)

iID iName sCreateDateTime iPrice
1 'zhang ' 2005-01-01 1.00
1 'zhang ' 2005-01-02 2.00
1 'zhang ' 2005-01-03 -1.00
2 'li' 2005-01-01 nill
2 'li' 2005-01-02 -1.00
2 'li' 2005-01-03 nill
................................................
.................................................
现在想得到
imount iID iName sCreateDateTime iPrice
1 1 'zhang ' 2005-01-01 1.00
2 1 'zhang ' 2005-01-02 2.00
3 1 'zhang ' 2005-01-03 -1.00
4 2 'li' 2005-01-01 nill
5 2 'li' 2005-01-02 -1.00
6 2 'li' 2005-01-03 nill.
........................................................
.........................................................
n.......................................................
sql怎么写？？？

如果是sqlserver,就得先插入临时表时加个,在select
select identity(int,1,1) as imount,* into #temp from 表
然后在查询,
oracle就简单了,直接有个函数,