1. सीखें
    2. /
  2. पाठ्यक्रम
    3. /
  3. Intermediate SQL Server
Connected

अभ्यास

Creating CTEs (II)

In this exercise, you will use a CTE to return all the information regarding the patient(s) with the maximum BloodPressure.

निर्देश

100 XP
  • Create a CTE BloodPressure that returns one column (MaxBloodPressure) which contains the maximum BloodPressure in the table.
  • Join this CTE (using an alias b) to the main table (Kidney) to return information about patients with the maximum BloodPressure.