编程论坛 → VFP论坛

挑选最大值信息

snail5007 发布于 2010-06-12 10:44， 508 次点击

只有本站会员才能查看附件，请登录

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

6 回复

lycheeva2010-06-12 12:12

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

lycheeva2010-06-12 12:15

只有本站会员才能查看附件，请登录

snail50072010-06-12 13:46

回复 3楼 lycheeva

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

lycheeva2010-06-12 15:21

只有本站会员才能查看附件，请登录

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

snail50072010-06-12 16:52

回复 5楼 lycheeva

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

chychychy2025-02-24 14:54

回复 5楼 lycheeva

程序代码：

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