如何挑选出所有井号（jh)的最大含水值（hs)值的信息？

SELECT jh,MAX(hs) FROM jshs group by jh 执行这条语句就可以了

同时也需要ny的信息，
jh,ny,hs三项信息都需要？
如何实现？
谢谢大哥

根据原表再执行SELECT * from jshs,a WHERE jshs.jh=a.jh AND jshs.hs=a.max_hs into table b

实在感谢，问题得到解决
谢谢~~`

SELECT jh, MAX(hs) AS max_hs FROM jshs GROUP BY jh INTO CURSOR temp

SELECT a.jh, a.ny, a.hs ;
FROM jshs a, temp b ;
WHERE a.jh = b.jh AND a.hs = b.max_hs

或者
SELECT a.* FROM jshs a ;
INNER JOIN (;
sele jh,MAX(hs) as hs FROM jshs GROUP BY jh ) b;
ON a.jh=b.jh AND a.hs=b.hs