Agree with most above points - it depends on the database.

I also think a better explanation is required as

The reason is that when we generate a RANK of top 20...

Had to look up what the different types of number were for some of them 🙂

Hmmm - the SalesAdjustments table doesn't exist in the statement 😛

Like it - but agree with above - dropping and recreating would achieve the same goal.

Lol - had to look up what Labor Day was (from across the pond 😉 )

+1 agree

There are definitely more than 2 correct answers here Shiva.

Nice start for a Monday - out of interest what are people's thoughts on running MSSQL on a Virtual Machine?

I've met a lot of resistance to the idea and haven't...

Agree with the above posts

I assume that the point is supposed to be that the inner query result affects the rows returned in the outer query - but this answer...

Good question - although it does ask for the "number of rows or the error" technically the number of rows returned in the result set is 1 🙂

Never come across this before - thanks

Cheers Andy - had to start off with all of them and eliminate one by one this time 🙂