Hello All, I have a table like pressure result that contains the multiple records based on a single parent record. The table structure like----- s.no parent id result 1 10 9.5 2 10 8.2 3 10 7.2 ... ... .... ... ..... .... 20 10 8.9 So now i need result like this:---- column header------1a 1b 2a 2b 3a 3b 4a 4b 5a 5c ............19a 19b 20a 20b column value----- 9.1 6.2 7.8......................................................9.8 8.7 |
Take a look at the other questions (and answers) that have been asked about pivot/unpivot - I believe that these answers will tell you how to do it. i.e. you need to construct a SQL statement based on your requirements and then EXECUTE IMMEDIATE the statement to get the result set.
HTH answered 20 Dec '13, 09:29 Mark Culp |