0

I have table with let say the below 3 columns

Date                    OfferId         Title   
4/29/16 - 5/19/16       123             title1
5/20/16 - 5/30/16       123             title2
5/31/16 - 6/2/16        123             title3
6/03/16 - 6/13/16       123             title1
6/14/16 - 6/16/16       123             title4
6/17/16 - 6/20/16       123             title2
6/21/16 - 6/25/16       123             title4

i have some other columns which need sum

Where i put range like this 4/29/16 - 5/19/16 it means i have multiple rows for those dates with the same title.

as you can see the

title1 is same between 4/29/16 - 5/19/16 and 6/03/16 - 6/13/16 
title2 is same between 5/20/16 - 5/30/16 and 6/17/16 - 6/20/16
title4 is same between 6/14/16 - 6/16/16 and 6/21/16 - 6/25/16

So when we do grouping on Title so what it does is return 4 results

select Min(Date),OfferId, Title from temp group by Title;

using the above query the results will be

Min(Date)   OfferId         Title   
4/29/16     123             title1
5/20/16     123             title2
5/31/16     123             title3
5/31/16     123             title4

what i wanted is it should be look like this so i can see all the history the title got changed.

Min(Date)   OfferId         Title   
4/29/16     123             title1
5/20/16     123             title2
5/31/16     123             title3
6/03/16     123             title1
6/14/16     123             title4
6/17/16     123             title2
6/21/16     123             title4

How can I achive this

1 Answer 1

0
SELECT (@prev = Title) AS same,
       Title,
       `Date`,
       @prev := Title AS t
    FROM ( SELECT @prev := '' ) AS Init
    JOIN ( SELECT `Date`, Title FROM tbl ORDER BY `Date` LIMIT 999999 ) AS x
    HAVING same = 0

See if that gets the right info, plus some junk. Then get rid of the junk:

SELECT `Date`, Title
    FROM ( the entire query above ) AS y
    ORDER BY `Date`
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.