SELECT TOP 2 * FROM tb WHERE rs>=jh ORDER BY rs
符合条件最小的值是65和108,你怎么得到的127?
SELECT INT(RECNO()) AS ID, * FROM tb WHERE rs>=jh ORDER BY rs INTO CURSOR temp SELECT MIN(ID) AS ID FROM temp GROUP BY cc INTO CURSOR temp2 SELECT cc AS CCDM,rs,jh FROM temp WHERE ID IN(SELECT ID FROM temp2) INTO DBF 结果 BROWSE
[此贴子已经被作者于2023-12-20 14:26编辑过]