I’m unable to get result using this query

create table Item
(
    Itemid int primary key ,
    ItemName varchar(100),
    CalorificValue int,
    price int 
)

​x
 
create table Item(    Itemid int primary key ,    ItemName varchar(100),    CalorificValue int,    price int )​

Task: what item has the highest price followed by the highest calorific value?

My query solution:

Select Itemname 
from Item 
where price = (Select max(price) from Item)
  and CalorificValue = (Select max(CalorificValue) from Item)

 
Select Itemname from Item where price = (Select max(price) from Item)  and CalorificValue = (Select max(CalorificValue) from Item)​

But I’m not getting the answer. Can anyone solve this issue?

Answer

Try the following with limit

select
    TOP 1 ItemName
from yourTable
order by
    price desc,
    CalorificValue desc

 
select    TOP 1 ItemNamefrom yourTableorder by    price desc,    CalorificValue desc​