6 I are convinced in 1st query you may have shared variable amongst outer question and subquery, so For each row in principal question, subquery executes but in 2nd a single the subquery only executes a single time which way efficiency improved. +----+-------------+----------+--------+---