name表如下：

如何从第一张表中查询得到第二张表？

select xm, min(px) as px from name into cursor 查询结果

select xm, min(px) as px from name group BY xm  INTO CURSOR lsname READWRITE  
SELECT * FROM lsname ORDER BY px asc

INDEX ON PX TAG PX
BROWSE

3 楼经验证正确，谢谢