Post reply

Query help for anniversary

  • April 20, 2015 at 12:20 am

    #317534

    I came with a case where i need help either i can do it in one uqery:

    I have to segregate members data for 1st year anniversary, 3rd year Anniversary, 5 yrs, 10 years and so on as per the joining date till 31 may 2015.

    And with in each year i have to divide the counts between no of activities for 1 year, 2 years, 3 yeards and so on...

    Please help me if it can be done?

  • April 20, 2015 at 2:03 am

    #1791940

    Please post table defintions as CREATE TABLE scripts, some sample data as INSERT statements and the expected results based on the sample data. For more info on how to do that correctly, see the article linked in my signature line.

    -- Gianluca Sartori

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply