Home » SQL & PL/SQL » SQL & PL/SQL » query problem
query problem [message #247459] Mon, 25 June 2007 23:33 Go to next message
lunate
Messages: 74
Registered: October 2006
Location: Pakistan
Member

Dear all;

i have a problem ,kindly help me to solve it.

the probelm is given below :

A table has the following structure:

Student Grade
A A
A B
A C
B A
B B
B D

Quote:

i want to :Write an SQL script which would produce the following required output:


Student Grades
A A,B,C
B A,B,D
Re: query problem [message #247460 is a reply to message #247459] Mon, 25 June 2007 23:44 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>i want to :Write an SQL script which would produce the following required output:
Since you have volunteered for this project, we won't get it your way.
After you have succeeded, please share the results back here.
Re: query problem [message #247467 is a reply to message #247459] Tue, 26 June 2007 00:57 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same old "pivot" query than several times per week.
Closed, search is there.
./fa/448/0/
Regards
Michel

[Updated on: Wed, 18 July 2007 07:41]

Report message to a moderator

Previous Topic: to know table name of specific data
Next Topic: PL/SQL: READ UTL_FILE using separator
Goto Forum:
  


Current Time: Sun Dec 11 08:01:06 CST 2016

Total time taken to generate the page: 0.11590 seconds