|
Re: convert rows to column in SQL [message #679444 is a reply to message #679442] |
Sat, 29 February 2020 00:58 |
|
Michel Cadot
Messages: 68658 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 100 characters when you format.
Indent the code, use code tags and align the columns in result.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
Quote:I want to convert rows to column in SQL
Have a look at PIVOT/UNPIVOT clause of SELECT.
[Updated on: Sat, 29 February 2020 00:59] Report message to a moderator
|
|
|