回复:there is no "last record"

回答: 回复:SQL statement about going tlidongmei2004-06-30 18:46:10

select top 1
user_ID,name,address,phone
from table1
order by user_ID desc

所有跟帖: 

This is for SQL Server, not -smartll- 给 smartll 发送悄悄话 (60 bytes) () 07/01/2004 postreply 01:02:23

It work in Access -tryyyyyy- 给 tryyyyyy 发送悄悄话 (0 bytes) () 07/01/2004 postreply 07:01:29

回复:回复:there is no "last record" -MD/PHD/IT- 给 MD/PHD/IT 发送悄悄话 (213 bytes) () 07/01/2004 postreply 13:35:43

请您先登陆,再发跟帖!