Home » SQL & PL/SQL » SQL & PL/SQL » Printing the column as rows in a table with the help of group by
Printing the column as rows in a table with the help of group by [message #246863] Fri, 22 June 2007 04:51 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I have a table, "sample" with data like

hz db/sql a.sql
hz db/sql b.sql
hz db/sql c.sql
hr db d.sql
hr sql a.sql

I need the output to be like


hz db/sql a.sql,b.sql,c.sql
hr db d.sql
hr sql a.sql

How can i do this ?
Re: Printing the column as rows in a table with the help of group by [message #246865 is a reply to message #246863] Fri, 22 June 2007 04:54 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Search for pivot.
There are several same questions per week.
This one is closed.
/forum/fa/448/0/
Regards
Michel
Previous Topic: spool into file
Next Topic: display all dates of monday for given year
Goto Forum:
  


Current Time: Mon Feb 17 22:28:24 CST 2025