How can I find the most expensive product in a Product table without using MAX, LIMIT, or ORDER BY in SQL Developer Oracle?

user_8225131 0
Viewed 56

I'm supposed to find it without using those, and I can't think of anything and haven't found any information. Thanks

oracle sql
2 Answers

Use NOT EXISTS:

SELECT *
FROM   product p
WHERE  NOT EXISTS (
  SELECT 1
  FROM   product x
  WHERE  p.price < x.price
)
user_15092640

You can do a self outer join on the price being lesser. Supposing you have a table products(id int, price int), you can find the id of the most expensive items using:

select p1.id
from products p1 left join products p2
on p1.price < p2.price
where p2.id is null;

Fiddle

user_176450990
Related