Pls help to solve SQL query!!!!?

Question

Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)

Find the model number of the product (PC, laptop, or printer) with the highest price.
Result set: model.

Answer 1

select model=
case
when (price1 >= price2) and(price1 >= price3) then model1
when (price2 >= price1) and(price2 >= price3) then model2
else model3
end
from
(select top 1 price as price1 ,model as model1 from PC order by price desc)a,
(select top 1 price as price2 ,model as model2 from Laptop order by price desc)b,
(select top 1 price as price3 ,model as model3 from Printer order by price desc)c,

Answer 2

You need to run three individual queries for this:
one example is here:

select model from product where model In (select model from PC where price = (select max(price) from PC))

Replace PC with Laptop and Printer for the respective products.

Answer 3

Try this....

Select subQ.Model, max(subQ.price)
from
(
Select a.model, b.price
From Product a, PC b
Where a.model = b.model
UNION
Select a.model, b.price
From Product a, LapTop b
Where a.model = b.model
UNION
Select a.model, b.price
From Product a, Printer b
Where a.model = b.model
) subQ
Group by subQ.Model

Answer 4

select model from
(
select model,price from PC where price=(select max(price)) from PC )
union
select model,price from PC where price=(select max(price)) from laptop )
union
select model,price from PC where price=(select max(price)) from printer )
)t1
where
price=(select max(price)) from t1)

i guess this will solve the problem ... bt the schema design is nt very gud ....... it can be better ....

Answer 5

could be between the parameters exceeded is empty. make advantageous Text5.text cloth isn't sparkling & has some fee. sometime such blunders happens once you do no longer pass a value for integer fields into sq. question. you need to use an if assertion to envision despite if Text5.text cloth is sparkling.

Answer 6

select top1 model,price from
(
select top1 model,price from PC order by price DESC
UNION
select top1 model,price from Laptop order by price DESC
UNION
select top1 model,price from Printer order by price DESC
)
order by price DESC

No need for sub-queries, no need for aggregates, you can extend it easy if u want to take from 5 more tables in future..

Answer 7

I am sorry dude i had done this programming long ago and now its a big Mountain for me.