Getting min values via sql

[-TPM-]

I think this is what you want:
SELECT MIN(VALUE) FROM HCOM GROUPBY MODULE

TPM