Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 

Qlik extraction of data from oracle

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.

If I am querying with select * from table I am getting two rows of data. 

Even when I do a SQL query to call out duplicates with group by order I'd having cnt(orderid)>1. I am getting 0 rows. 

Can anyone explain this please.

Labels (1)
0 Replies