怎样能把这条在sqlserver运行的sql语句放在access里运行???

[tudoux]

有表T
id Uid Str
1 5 aaa
2 5 bbb
3 5 ccc
4 6 ddd
5 6 eee
6 8 ggg
7 8 ttt
8 2 uuu
9 2 hhh

要得到结果
id Uid Str
9 2 hhh
1 5 aaa
4 6 ddd
6 8 ggg
8 2 uuu
2 5 bbb
5 6 eee
7 8 ttt
3 5 ccc
在sqlserver里下面这个可以
select a.* from @t a order by (select count(*) from @t b where b.Uid=a.Uid and b.str<a.str),a.uid

在access怎样写??

[changechange]

select a.* from 表名 as a order by dcount("*","表名","表名.uid=" & a.uid & " and b.[str]<'" & a.str & "'"),a.uid


上述代码必须在纯 ACCESS 环境下运行 ,ASP + MDB 这样的环境无法运行

[changechange]

新手来看：Access的特点、概念。什么是纯 ACCESS 环境？《其他》
http://access911.net/index.asp?u1=a&u2=79FAB51E12DC







--911--

[wwwwb]

select a.*,(select count(*) from t b where b.Uid=a.Uid and b.str<a.str) as px
from t a
order by px,a.uid

[tudoux]

在access有没别的方法得到上面的结果,在asp里调用

[tudoux]

a,b实际是同一个表来的

[OracleRoob]

用一个子查询即可：


select *
from
(select
a.*,
(select count(*) from t b where b.Uid=a.Uid and b.str<a.str) as px
from t a
) TP
order by px,uid