You have a query similar the example below.
CREATE TABLE TEST (aa varchar(20));
INSERT INTO TEST (aa) values('Hello');
FROM (select max(aa) dd from TEST where aa = 'gkgkgkg') aa;
And noted that it returned a different result set between SAP IQ 15.4 and IQ 16.0 SP11.03 and higher
- SAP IQ 15.4
- SAP IQ 16.0
count(), count, max(), max, incorrect result set, wrong result set , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.