rahul2671985 (9/14/2010)
I didnt get the exists condition here.. hw it works? can anyone explain me plz?Thanks,
rahul
Rahul, please follow the entire discussion from page# 1, and I am sure you will get it. Essentially, both the WHERE and HAVING conditions are ultimately evaluated as boolean conditions - if the ultimate result is true, the particular record stays in the result set; else it is discarded.
What this question also illustrates very well is the logical query processing order, which is also clarified throughout the discussion.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins