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.