Results 1 to 2 of 2
Thread: SUM Problem
Sep 23, 2010, 03:33 #1
I am stuck. Please help!
CREATE TABLE CHARS_COUNT (ID NUMBER(4) NOT NULL,
I wish to get the following output:
* Sum of Total Characters by pertaining to each EditorID.
the problem is I don't want to include all the rows for SUM. ONly latest row to be used pertaining to each editor to be used for SUM.
if editorId = 1 edited thrice then system must only include latest row i.e. row3 during summation.
Thanks in advance.
Sep 23, 2010, 04:01 #2