27,579
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
「已注销」 2002-10-22
- 打赏
- 举报
我给出答案，希望大家给出比这个好的方法！
sql1 = "SELECT TOP 50 max(ATime)as InserTime FROM tinfo_ip ORDER BY TIME DESC where uid='" & uid & "'"
sql2 = "DELETE FROM tinfo_ip WHERE TIME<=" & InserTime
合并为最佳
sql1 = "SELECT TOP 50 max(ATime)as InserTime FROM tinfo_ip ORDER BY TIME DESC where uid='" & uid & "'"
sql2 = "DELETE FROM tinfo_ip WHERE TIME<=" & InserTime
合并为最佳
