SUM Problem

Databases
1

Hello Guys,

I am stuck. Please help!

CREATE TABLE CHARS_COUNT (ID NUMBER(4) NOT NULL,
TotalChars NUMBER(10),
EditorID NUMBER(5))

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.

eanimatoR

2

Sorted it out =)