How can I use a value from another field

Say if I have just the id of a certain row, and in that row is also a price (which I don’t have). I want to find the rows with higher prices. I would normally do multiple SELECT queries, but was wondering if there’s a way to do this in one.

SELECT price FROM tablename WHERE id = $id
SELECT * FROM tablename WHERE price > $price

So putting these two statements together. Thanks

I’ve not tested this but something like this:

$sql = SELECT * FROM tablename WHERE price > (SELECT price FROM tablename where id = $id LIMIT 1);

There may be an even simpler way to do it, but this is how I would do it.