What is Difference between Temp, CTE and Subquery

Hi Every one, I have been asked a question in one of the interview that what is the difference between Temp table, CTE and Sub query? Anybody can give the proper answer, even i know the answer but what can be the appropriate answer? Waiting for your response.

  Devbrat Tripathi

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any