https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-extraction-of-data-from-oracle/m-p/1854746#M9786 <P>In my table there is one column called OrderID it has only two duplicates of I'd 12345. When querying with Where orderid = '12345' I am getting only 1 row.</P> <P>If I am querying with select * from table I am getting two rows of data.&nbsp;</P> <P>Even when I do a SQL query to call out duplicates with group by order I'd having cnt(orderid)&gt;1. I am getting 0 rows.&nbsp;</P> <P>Can anyone explain this please.</P> Tue, 02 Nov 2021 14:58:43 GMT rammarthi 2021-11-02T14:58:43Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-extraction-of-data-from-oracle/m-p/1854746#M9786 <P>In my table there is one column called OrderID it has only two duplicates of I'd 12345. When querying with Where orderid = '12345' I am getting only 1 row.</P> <P>If I am querying with select * from table I am getting two rows of data.&nbsp;</P> <P>Even when I do a SQL query to call out duplicates with group by order I'd having cnt(orderid)&gt;1. I am getting 0 rows.&nbsp;</P> <P>Can anyone explain this please.</P> Tue, 02 Nov 2021 14:58:43 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-extraction-of-data-from-oracle/m-p/1854746#M9786 rammarthi 2021-11-02T14:58:43Z