Finding max value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This seemed a simple one for me, but got stuck somewhere. Can somebody help?

I have a table with readings of several instruments on different dates.
There are several hundreds instruments. For some instruments, reading may
not be taken every day. There are no readings taken on weekends and holidays.

I need a query that will accept as input the name of the instrument and a
date range (start date and end date). For this combination of input
parameters I want to determine what was the max and min reading for the
instrument - and the date of this max and min reading.

If putting both the max and min in the same query can complicate affairs
then I do not mind having one query for max value, and another query for min
value.

Can someone help?

Many thanks in anticipation.
.

Relevant Pages

  • Re: standard notation vs tabs
    ... reading is FUN - work, ... most keyboard players ... frustrating cuz you run into KBD players that CAN'T play unless they ... it's the nature of the instruments, AND, i suspect the nature of the ...
    (alt.guitar.beginner)
  • Re: Mentally unstable airline pilot forcibly removed from flight deck
    ... It is unlikely that she had 767 specific training, but the pilot knew ... And the other thing is that landing the jet is not rocket science... ... Are you reading ... reading cockpit instruments had expired." ...
    (rec.aviation.piloting)
  • Re: Mentally unstable airline pilot forcibly removed from flight deck
    ... It is unlikely that she had 767 specific training, but the pilot knew ... Are you reading ... she held a current commercial pilot's license but said her license for ... reading cockpit instruments had expired." ...
    (rec.aviation.piloting)
  • Re: 0-45° / Sphere instrument correlation
    ... Net profiler works with both sphere and 45:0 instruments but it will not mix ... correcting a d:8e reading to a 45:0 reading. ... deltaE2000 between measurements made on those ...
    (sci.engr.color)
  • Re: optimizer behaviour changed
    ... Given you have also done an order by which is not in the select list - the server must build an index to reorder the data which he is reading directly from the index. ... QUERY PLAN FOR STATEMENT 1. ... Using I/O Size 2 Kbytes for index leaf pages. ... With LRU Buffer Replacement Strategy for index leaf pages. ...
    (comp.databases.sybase)