Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLwindow functions ROW_NUMBER RANKSingle-choice MCQ

Given this query on duplicate prices, what values appear in the rnk column for the two rows priced 100?

-- rows: (A,100),(B,100),(C,90) SELECT name, price, RANK() OVER (ORDER BY price DESC) AS rnk FROM products;