[thesite] t.e.o. updates
.jeff
jeff at members.evolt.org
Sun Nov 18 15:51:31 CST 2001
rudy,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: rudy
>
> that's causing the error, but rather
>
> SELECT contentid, rand.random AS randum
> RANK() OVER
> (ORDER BY randum ASC NULLS LAST) AS contrank
> FROM content
>
> which, i figured, was a faithful reproduction of the
> syntax i saw in that devx article
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
yup, that's indeed what's causing the error as i get the same error when i
try to run the above by itself.
i double-checked the syntax (from the article about top-n queries that you
posted) and everything is kosher. i don't know why it won't work for us
here.
thanks,
.jeff
http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/
More information about the thesite
mailing list