|
On 18-May-2015 18:35 -0500, Hoteltravelfundotcom wrote:
midrange.com
I am getting error:
Keyword ROW_NUMBER not expected. Valid tokens: FROM INTO.
<<SNIP>>
Select * from
(
Select *
row_number() over (partition by [Otord#]
order by case ottrnc when '001' then 1 else 2 end
, ottrnd, ottrt
)
as RowN
from Rklib.clspaytp
) a
where a.RowN in (1,2)
A -104 aka SQL0104 as Syntax Error. The problem occurs as ROW_NUMBER in the currently coded\failing statement. So syntactically, what is wrong with the following?:
select * row_number() ...
The first token after the SELECT asks to included all columns from
the file. The second token requests to include the ROW_NUMBER() for a
second column. The SELECT expression\column-list is a comma-separated
list. Thus, try the following:
select *, row_number() ...
The next syntax error will be for the '[' and ']' characters which
are not supported as delimiters [for anything AFaIK] in the SQL. If the
column name is mixed-case, then the proper delimiters are the '"' [i.e.
the double-quote character].
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.
