赞
踩
1、select top %d * from test where (id not in (select top %d id from test order by id)) 2、获取记录总数 open时第三个参数要设置为:adOpenStatic;然后m_pRecordSet->RecordCount就可获取查询记录数。否则RecordCount值一直会是-1;