• 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