请问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

[wwwwb]

try:
SELECT *,(select count(*) from a3 where fdate<=a.fdate) as fid from a3 a;
a3为你的表名，可自行修改名称

[wwwwb]

or
SELECT dcount('*','a3','fdate<=#' & a.fdate & "#") AS fid, *
FROM a3 AS a;

[子陌红尘]

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

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

[developCpp]

谢谢wwwwb()
下面还是同样的问题, 顶一下接分就行
http://community.csdn.net/Expert/topic/5003/5003189.xml?temp=.386059

[wwwwb]

or
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

[wwwwb]

or
SELECT a.fDate, a.fData, count(*) from a3 a left join a3 b on a.fdate>=b.fdate
GROUP BY a.fDate, a.fData;