SAP Knowledge Base Article - Preview

3090496 - IQ returns the wrong number of results when using "TOP xx start at xx" - SAP IQ

Symptom

IQ 16.1 returns the wrong number of resuts when using "TOP xx start at xx"
This issue is data dependent and rarely occurs.

SELECT TOP 10 start at 1000
 col1,
 col2
FROM  tableA
ORDER BY  col1 ASC,  col2 ASC;

col1 col2
---- ----------------
1007 10AX027H1F34E1SG
1007 10AX027H1F34E1SP
1007 10AX027H1F34E2SG
1007 10AX027H1F34I1HG
1007 10AX027H1F34I1SG
1007 10AX027H1F34I2LG
1007 10AX027H1F35E1HG
1007 10AX027H1F35E1SG
1007 10AX027H1F35E2SG
1007 10AX027H1F35I1HG
1007 10AX027H1F35I1SG
1007 10AX027H1F35I2LP
1007 10AX027H2F34E1HG
1007 10AX027H2F34E1SG
1007 10AX027H2F34E2LG
1007 10AX027H2F34E2LP
more rows.


Read more...

Environment

  • SAP IQ 16.x

Product

SAP IQ 16.1

Keywords

IQ, SAP IQ, 16.1, SELECT, TOP, START, wrong results, incorrect results , 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 ONE Support launchpad (Login required).

Search for additional results

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