highest and lowest

  • Thread starter Thread starter chris
  • Start date Start date
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highest and Lowest Numbner 3
Comparing weeks with highest and lowest sales Query--HELP 6
Find highest and lowest number 3
I need 3 sql help 2
How do i plot two series of data both in accending order on a line 1
Min not working 2
Last Date Query 1
Alternating Purchase and Sale Records 1

Back
Top