Home » RDBMS Server » Server Administration » Help on crosstab query for oracle
Help on crosstab query for oracle [message #373040] Fri, 23 March 2001 12:28 Go to next message
Lisa Cheng
Messages: 2
Registered: March 2001
Junior Member
Hi, I need help on the following query to be woring in Oracle. Thanks.

TRANSFORM Sum(tblRequests.Cost) AS SumOfCost
SELECT tblRequests.ProjectNum, tblRequests.Title
FROM tblRequests
WHERE tblRequests.FiscYear Between 1997 And 2001
GROUP BY tblRequests.ProjectNum, tblRequests.Title
ORDER BY tblRequests.ProjectNum
PIVOT tblRequests.FiscalYear In (1997, 1998, 1999, 2000, 2001);

Lisa Cheng

Report message to a moderator

Re: Help on crosstab query for oracle [message #373112 is a reply to message #373040] Wed, 28 March 2001 02:38 Go to previous message
Leonard
Messages: 9
Registered: March 2000
Junior Member
No one to help on this one? I have a similar problem.

Report message to a moderator

Previous Topic: recursive sql? Im stuck
Next Topic: Re: Finding Orphan Records
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:28:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.