Comment ajouter la valeur maximale dans une variables ?

0
866

Transactions:

SQL SELECT

trn_uid,

trn_no,

trn_calendarDate,

trn_fiscalDate

FROM transact;

 

Temp:

load

max(trn_calendarDate) as maxCDate

,max(trn_FiscalDate) as maxFDate

resident Transactions;

 

LET vMaxCal = peek(‘maxCDate’);

LET vMaxFiscal = peek(‘maxFDate’);

 

drop table Temp;

LEAVE A REPLY

Please enter your comment!
Please enter your name here