CODE EXAMPLE FOR SQL

sql select max value from multiple rows

SELECT name,price FROM fake_apps
WHERE price = (SELECT max(price) FROM fake_apps);