Hi ,

I guessed correctly as 4.but i executed the script it is throwing error in the last statement.because group by is not there in the last statement.

Is it working for sqls server 2005 or 2008?

after throung error i put group by and executed it is showing zero rows.

unfortunately i put answer as zero but anser is correct.