🎴 Flashcard Mode
C# and SQL Programming
Card1 / 20
Mastered0
Review0
QuestionClick to flip
This query requires me to denormalize information in three different tables and then join the results. Fortunately, I only need to do it one time. What is the best choice for this situation?
AnswerClick to flip back
A
Derived Table
💡 Explanation:
Derived tables (subqueries in FROM clause) are ideal for one-time transformations because they exist only during query execution. For a single denormalization task, creating temporary tables adds unnecessary overhead and object management.