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
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.
Previous Topic: recursive sql? Im stuck
Next Topic: Re: Finding Orphan Records
Goto Forum:
  


Current Time: Mon Dec 23 05:38:03 CST 2024