Get the biggest price using MAX() function

I am using SQL Oracle, and I want to change my query using MAX function and not ROWNUM.

SELECT * 
FROM (SELECT a.name, price.price
FROM price
LEFT JOIN a 
ON a.id = price.tk_a
ORDER BY price.price DESC)
WHERE ROWNUM <=1;

Any help or suggestions please?

Source: New Questions

Leave a Reply