I have a sql that return these columns.
My question is, if it can take values from a colum and make these values to new columns and take a value from a second column to these new columns. Values for the new columns are price column. Like this:
|
Have a look at SQL Anywhere 17's PIVOT feature. Alternatively, try this: Crosstab, Rotate, Pivot 1
Version 17? Man, I seem to have missed something by not having taken part in the current summit:)
(27 Nov '14, 17:52)
Volker Barth
Replies hidden
Agree :), me too. I have heard about v17. But not much.
(28 Nov '14, 04:59)
Vlad
1
Yes, there is much that is cool coming in 17... there may even be room for a "Top 17 Cool New Features" article :)
(28 Nov '14, 07:38)
Breck Carter
when will version 17 be released, is there somewhere you can read about the new features?
(28 Nov '14, 12:42)
M G
Replies hidden
1
SQL Anywhere 17 may be feature-complete at the end of 2014 and released in the third quarter of 2015. No mention has been made of a beta, and if recent history (Raspberry Pi) is any indication,
(28 Nov '14, 14:07)
Breck Carter
|
As you have yourself used the "pivot" tag, just have a look at the other FAQs with that same tag...