I need a SQL selection statement that needs to be changed
1 2 3 4 < / Code> >> In 1 2 3 4 Without using the PIVOT function, as I searched the Internet on the Internet I , But surprisingly nothing was found.
A little help?
You can efficiently use a pivot by using cross JOI: / P> Select Max (when SqNum = 1 then TOL end) col1, max (case when seqnum = 2 then TOL end) col2, Max (case when seqnum = 3 then t.col end) col3, max (case when seqnum = 4 then t.col end) to col4 (select t, *, from row_number ()) (sequence by null) seqnum From T to T) T
No comments:
Post a Comment