var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Newbie questions
I have a two questions. I have used SQL before, mainly for Oracle.
There is a command break on <column> skip 1. Does anyone know the equivalent to this commnad, in db2?
How do I compute on a column in db2? This is to get totals.
All help is greatly appreciated.
First of all, "BREAK ON <column>" is not a SQL statement; it's a SQL*Plus command and as such it has no equivalent in DB2 Command Line Processor.
Use an aggregate function:
SELECT DEPT, SUM(SALARY) FROM EMPLOYEE GROUP BY DEPT