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 ONE Support launchpad (Login required).

Search for additional results

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