thuybi
More than likely it is a typographical error, for example the following is missing the ) directly after the asterik
select grp,subgrp,
count(* OVER
Should be
select grp,subgrp,
count(*)OVER
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]