SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: SUM Problem

  1. #1
    SitePoint Addict eanimator's Avatar
    Join Date
    Sep 2005
    Posts
    396
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SUM Problem

    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. #2
    SitePoint Addict eanimator's Avatar
    Join Date
    Sep 2005
    Posts
    396
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorted it out =)


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •