[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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