Untitled
Anonymous
Plain Text
07/25/2024 3:28 AM
268 B
20
Indexable
Never
SELECT carmake, carmodel, carlistprice AS "Highest List Price"
FROM (SELECT carmake, carmodel, carlistprice, ROW_NUMBER() OVER(PARTITION BY carmake ORDER BY carlistprice desc) AS row_number
FROM si.car
WHERE carlistprice IS NOT NULL)
WHERE row_number = 1;
Editor is loading...
Leave a Comment