Suppose you have issued a sql-select which returns several records containing the fields COST and SITE among others. Then suppose you want to select from this result the minimum COST and its corresponding SITE. As in:

select min(cost), site from crs1

This produces an error Group clause invalid. How should this second select be structured?


Thanks for your suggestions.