@sreshtha.
The inner query here returns 0 (and not NULL) as count(*) always returns some count.
I executed a similar query in MYSQL where the inner query returns 0.
EXISTS(0) is true.
So, select * from T where true
returns all the tuples in the table.