Câu 30: 70-761: Querying Data with Transact-SQL

HOTSPOT -Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series. You query a database that includes two tables: Project and Task. The Project table includes the following columns: The Task table includes the following columns: Users report performance issues when they run the following query: You need to improve query performance and limit results to projects that specify an end date. How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area. Hot Area:

1. A. Lựa chọn A bằng hình ảnh — đáp án hiện tại