Re: finding minimums

[Deb Maynard <Debra_Maynard@DOT.CA.GOV>]

Thanks...it looks good...I'll give it a try!!




itzgee <itzgee@PRISMNET.COM> on 10/05/99 03:28:27 PM

Please respond to SQR-USERS@list.iex.net



 To:      Multiple recipients of list SQR-USERS
          <SQR-USERS@list.iex.net>

 cc:      (bcc: Debra Maynard/HQ/Caltrans/CAGov)



 Subject: finding minimums







The minimum should be the easier of the two.

Select employee id, target_date

  !call two separate functions, one that gets the min and one that gets the
max

  let $employ = &employee_id
  let $target_date = &whatever

  do get-min-time
  do get-max-time


get-min-time
select min(to_number((substr(&comments, [ insert code here]))))  &min_time
from some-table yada yada yada


get max time
select
max(to_number((substr(&comments, [ insert code here]))))  &max_time
from some_table

yada yada yada