# SQL 的问题

Posted by 小贤 on November 23, 1997 at 07:41:58:

对不起再提一次这个问题!
我要先依日期排序,再取出前5笔记录,再找出前5笔记录的最高,最低 值
Dim Db As Database
Dim Rd, Rd2 As Recordset
Set Db = OpenDatabase(App.Path & "\A.mdb")
Set Rd2 = Db.OpenRecordset("select top 5 * from K order by 日期")
Set Rd = Db.OpenRecordset("select max(高) as 最高 , min(低) as 最低 from rd2")

在 set rd 时会错误!
有其它方法吗?还是我用法错误呢?

Follow Ups:

- 当然不对 小吴 01:39:55 11/25/97 (0)