Max(), Min() Problem

[Guest]

I have a table with several "ref" values for a given "SH". I would like to
find the min and max ref per sh. I have:
Select sh,MAX(rm) as Maxrm, MIN(rm) as Minrm
From table;

I get the error:
"you tried to execute a query that does not include the specified expression
'sh' as part of an aggregate function"

I've tried several different setups and still not what I am looking for a
result.
Any Help is greatly appreciated, Thanks in advance
Ken

 

[Duane Hookom]

Select sh,MAX(rm) as Maxrm, MIN(rm) as Minrm
From table
Group By sh;

 

[Guest]

I'm a not so smart beast of burden, I should have known that.

Worked great, thanks for the help