Untitled
unknown
plain_text
a year ago
268 B
4
Indexable
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