SAP Knowledge Base Article - Preview

2302466 - Select Distinct Get Wrong No. of Records - SAP IQ

Symptom

Customer found that the number of records returned from the following is different:
   
    select distinct Col_A, Col_D from Table_Main; (3 records)
    select distinct Col_A from Table_Main; (2 records)


Read more...

Environment

  • SAP IQ 16.0 SP08 PL32
  • SAP IQ 16.0 SP11

Product

SAP IQ 16.0

Keywords

select,distinct,group by , CR#797575, CR797575, 797575 , , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.