Creating CTEs (II)
In this exercise, you will use a CTE to return all the information regarding the patient(s) with the maximum BloodPressure.
Latihan ini merupakan bagian dari kursus
Intermediate SQL Server
Instruksi latihan
- 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.
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
-- Create the CTE
WITH ___
AS (___)
SELECT *
FROM Kidney a
-- Join the CTE
___
___