请问SQL怎么给查询添加一个自动编号的字段呢？

[developCpp]

例如：表　table1 (fDate,fData)
fDate , fData
--------------------
2006/2/2 , 1234
2006/5/3 , 1111
2006/7/5 , 2222
2006/8/6 , 3333
2006/8/8 , 4444
2006/9/9 , 5555

查询取值添加自动编号字段　fID
fID , fDate , fData
------------------------------------
1 , 2006/2/2 , 1234
2 , 2006/5/3 , 1111
3 , 2006/7/5 , 2222
4 , 2006/8/6 , 3333
5 , 2006/8/8 , 4444
6 , 2006/9/9 , 5555

谢谢

下面还有同样的问题，是Access的(100分)
http://community.csdn.net/Expert/topic/5003/5003145.xml?temp=.3801844

[九斤半]

临时表

[九斤半]

晕，ACCESS的不懂

[fuyu006]

select fid=identity(int,1,1) ,fdate,fdata from table1

[lxzm1001]

alter table tablename add id int identity(1,1)

[子陌红尘]

select identity(int,1,1) as fid,fdate,fdata into # from table1

select * from #

drop table #

[xiaoku]

临时表：你是不是想更改那表结构阿？


select fid=identity(int,1,1)，fdate,fdata into #t from table1

直接查询 select * from #t

[子陌红尘]

如果每天只有不超过一条记录，可以用子查询方式实现，同样适用于Access：

select
(select count(*) from table1 where fdate<=t.fdate) as fid,
t.fdate,
t.fdata
from
table1 t

[fuyu006]

不好意思，写错了。

create table table1 (fdate datetime,fdata varchar(4))

insert into table1
select '2006/2/2','1234'
union all
select '2006/5/3','1111'
union all
select '2006/7/5','2222'
union all
select '2006/8/6','3333'
union all
select '2006/8/8','4444'
union all
select '2006/9/9','5555'


select fid=identity(int,1,1),fdate,fdata
into #t
from table1

select * from #t

[developCpp]

每天只有一条纪录
thanks very much
trying.....

[fuyu006]

create table table1 (fdate datetime,fdata varchar(4))

insert into table1
select '2006/2/2','1234'
union all
select '2006/5/3','1111'
union all
select '2006/7/5','2222'
union all
select '2006/8/6','3333'
union all
select '2006/8/8','4444'
union all
select '2006/9/9','5555'


select fid=identity(int,1,1),fdate,fdata
into #t
from table1

select * from #t

insert into #t
select '2006/8/9','6666'

select *from #t order by fid

呵呵，只会只一种方法，其它的就不知道了，期待。。。。。。。。

[wwwwb]

select fDate,fData,count(*) as fld from (
SELECT a.* from a3 a left join a3 b on a.fdate>=b.fdate)
group by fDate,fData