|
Hi, I am trying to use the Rownum() over() OLAP function but without much success. My query is "select field1, rownum() over(order by field1) as rownum from <library>.<fileName> where field1 like 'A%' and rownum < 10" I expect it to fetch me the first 10 records where field1 is like 'A%' ...but i get a SQL0104 Token ( was not valid. Valid tokens: , FROM INTO. Cause . . . . . : A syntax error was detected at token (. Token ( is not a valid token. What am I doing wrong ? Do i need any special libraries to use these functions ? Lastly forgive me if this is not the right forum, in which case can anyone guide me to the right one. TIA Narsi
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
