Code: Select all
select cast (month as int)||'/'||cast (day as int) ||'/'|| cast (year as int) Date, transactionNumber,
'$'||printf("%.2f", amount) as Amount
from alldata
where substr (date,1,4) = '2015'
and (transactionNumber like '1%'
or transactionNumber like '2%')
order by transactionNumber, year, month, day
basically I want a new page to be created every time the transactionNumber changes. How can I do that?