Hi everybody,

I'm trying to figure out some strange phenomena.

I have a huge database. I have two similar written queries. One produces 34447 records and another produces 30242.

So, I want to see the difference and first I tried

select * from bigger query
EXCEPT
select * from lesser query

and I got 0 results.

I also tried

select * from bigger query where not exists (select 1 from lesser query)

and again I got 0 results.

Can you please explain it to me.

BTW, the lesser query is written quite strangely and the reason I wrote another query is because I can not understand the original one.

Thanks in advance.