| Unsupported OVER Keyword [message #94408] |
Thu, 14 October 2004 23:02 |
A.G.Chandrashekhar
Messages: 2
Registered: October 2004
|
Junior Member |
|
|
Hi,
I have a sql query similar to following:
SELECT product_seq, event_source MAX(product_seq) OVER (PARTITION BY event_source) max_product_seq
FROM pvcusteventsource;
And table desc:
Name Null? Type
PRODUCT_SEQ NOT NULL NUMBER(9)
EVENT_SOURCE NOT NULL VARCHAR2(40)
I see OVER keyword is not being supported by proc. I am using following version on AIX & Solaris.
(Pro*C/C++: Release 9.2.0.5.0 - Production on Fri Oct 15 07:03:44 2004)
Can I have help in modifying the query without OVER keyword or any other work around?
Thnaks in Advance.
-shekhar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
