SAP Knowledge Base Article - Preview

2061100 - Incorrect result against a select statement having a RANK()

Symptom

  1. IQ server returns an incorrect result against a select statement having a RANK below.
  2. Problematic sql

 select *
  , rank() over( partition by col1 order by col3 ) min_rank
  , rank() over( partition by col1 order by col3 desc ) max_rank
  from ztmp
  order by 3;

  1. Incorrect result

col1    col2    col3    min_rank     max_rank
  AA      BA      11       2              2                // should be  1 for min_rank
  AA      BA      22       1              1                // should be  2 for min_rank
  AB      BA      33       3              3                // should be  1 for min_rank
  AB      BB      44       2              2                   
  AB      BB      55       1              1                // should be  3 for min_rank


Read more...

Environment

SAP SYBASE IQ 15.2, IQ 15.4 IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

Incorrect result, RANK, Row_Number , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.