access中有ROWNUM吗？

[zhangtenyu]

在oracle的sql中有个关键字ROWNUM,可以返回当前记录的行号。
例如：
SQL> select ROWNUM,name from t1 order by name;

ROWNUM NAME
---------- --------------------
6 ZHANG
5 Zh
3 other
1 zhang1
4 zhang2
2 zy

请问在access(Microsoft Jet SQL)中有没有相同或类似的关键字(不是top,我需要得到行号)，谢谢！

[奇遇]

There should be not this function in access.

[hycao]

没有~~~~~~

[w_rose]

create table myTable (rowNum counter,......)

[hyh888]

给数据库添加一个自动编号字段,搞定.

[fjfzman]

可以做一个查询，用WHERE语句：
where mytable.rownum=5 （大意）

[奇遇]

U can add a autoincrement or counter type column named 'idnum'.
Then U can use the following query get rownum.

SELECT dcount("idnum","t1","idnum<="&idnum) as ROWNUM,name from t1 order by name;

But the efficiency of this query not so well :)

[fjfzman]

not so well?
chinese English?

[奇遇]

^_^ 拼音不好，又不会五笔，只好献丑了 ：）