highest and lowest

[chris]

is there any way to filter each group by the "lowest"
or "highest" data point for a set?

ex.

Cust Sale Amt
Customer A $5.00
Customer A $8.00
Customer A $7.00

Filter for "lowest", brings only 1st entry ($5)

Thanks,
chris

 

[Pavel Romashkin]

Perhaps

SELECT Min([Sale Amt]) FROM MyTable GROUP BY Cust

Pavel