Category : Files from Magazines
Archive   : DBMS0790.ZIP
Filename : ROTI5.JUL

 
Output of file : ROTI5.JUL contained in archive : DBMS0790.ZIP
Listing 5


SELECT customer,
SUM(DECODE(TO_CHAR(sale_date,'YY'),'87',
amount,0)) amt_1987,
SUM(DECODE(TO_CHAR(sale_date,'YY'),'88',
amount,0)) amt_1988,
SUM(DECODE(TO_CHAR(sale_date,'YY'),'89',
amount,0)) amt_1989
FROM cust_row2
GROUP BY customer



  3 Responses to “Category : Files from Magazines
Archive   : DBMS0790.ZIP
Filename : ROTI5.JUL

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/