[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
finding minimums
- Subject: finding minimums
- From: itzgee <itzgee@PRISMNET.COM>
- Date: Tue, 5 Oct 1999 17:28:27 -0500
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