Let me add another important step to Richard's answer:
divide and conquer
Split the problem into smaller pieces until you can solve each of those smaller pieces. If you can't solve it yet, try to split it further.
In case you are later stuck with a specific problem, come back to this site and ask a specific question.
Don't use MySQL but in SQl server you would do this:
,ROW_NUMBER() OVER (
) AS RowNumber
WHERE RowNumber > 1;
I'm an optoholic - my glass is always half full of vodka.
I'm facing a real challenge in a report I've built with MDX in SSRS.
I have "Keywords" (Dim) column, and "Cost" (Measure) column.
There are a lot of the same keywords (each from different Campaign, which name I preset in the KW tool tip).
I need to make sure that all KWs from the same kind will display one after the other.
The problem is, I need to make sure it's stays in that order even when sorting (interactively) the "Cost" column. basically, the sorting will start again after each group of keywords. And I must display each one of the KWs, not grouping them to 1.