LutzM (1/10/2012)
@Craig: Answer A has an ORDER BY but invalid syntax.
My foot tastes GREAT! I think I'll swallow to the knee next time.
The problem in general from my point of view:
There's a company looking for someone with decent SQL skills since they obviously don't have anybody at the team yet. Or they're trying to ask a bunch of trick questions just for the fun of it, and missed to include the fun part.
But if you (JagWalia) cannot spot the errors in the questions/answers and provide a reason why those are wrong, you're probably not the one they're looking for. The company seems to look for someone to teach, not to learn...
+1
I'd definately have to agree with this. I wouldn't trust the rest of the questions offhand either.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA