Creating CTEs (II)
In this exercise, you will use a CTE to return all the information regarding the patient(s) with the maximum BloodPressure.
Bu egzersiz
Intermediate SQL Server
kursunun bir parçasıdırEgzersiz talimatları
- Create a CTE
BloodPressurethat returns one column (MaxBloodPressure) which contains the maximumBloodPressurein the table. - Join this CTE (using an alias
b) to the main table (Kidney) to return information about patients with the maximumBloodPressure.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create the CTE
WITH ___
AS (___)
SELECT *
FROM Kidney a
-- Join the CTE
___
___