Skip to main content
All Problems
easy0% acceptance

Second Most Expensive Product

Find the product with the second highest price. Return its name and price. If there are ties for the highest price, the second highest should be the next distinct price below the maximum.

Schema

🔑idINT
nameTEXT
🔗category_idINT
priceREAL
costREAL
stock_quantityINT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute