EXISTS() vs. SELECT COUNT(*) vs. EXISTS (SELECT *)

[skhanal]

In other words, the second query is not logically same as other queries.