SELECT cost, site FROM crs1 c1 ; WHERE cost = (SELECT MIN(cost) FROM crs1 WHERE site = c1.site)>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 >>