OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » query problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query problem [message #247459]

Mon, 25 June 2007 23:33

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

Report message to a moderator

Re: query problem [message #247460 is a reply to message #247459]

Mon, 25 June 2007 23:44

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: query problem [message #247467 is a reply to message #247459]

Tue, 26 June 2007 00:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same old "pivot" query than several times per week.
Closed, search is there.
/forum/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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 07:08:42 CST 2024