时间戳

首页 > 解决方案 > 当 DB Sailfish 中没有数据时出现 ROW_NUMER() 错误

sql - 当 DB Sailfish 中没有数据时出现 ROW_NUMER() 错误

问题描述

仅当数据库（Sailfish/ibm db2 zos）中不存在数据时，我才会面临一个奇怪的错误。所有列都是整数。

SELECT jersey_number,
       team_nm,
       ROW_NUMBER ()
       OVER (
          PARTITION BY Model_Football.member_idn,
                       Model_Football.Arm_Power_Idn,
                       Model_Football.Speed_Idn
          ORDER BY
             Model_Football.member_idn,
             Model_Football.Arm_Power_Idn,
             Model_Football.Speed_Idn)
          AS Dual_threat_id
FROM QB_SCHOOL
WHERE pos = 'QB'

[IBM][DB2/LINUXPPC64LE] Invalid character found in a character string argument of the function "DECFLOAT".

标签： sqldb2partitioning

解决方案

推荐阅读