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 adalah bagian dari kursus
Intermediate SQL Server
Petunjuk 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 praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Create the CTE
WITH ___
AS (___)
SELECT *
FROM Kidney a
-- Join the CTE
___
___