|
Posted by DickChristoph on 03/30/06 17:48
Hi Daniel
Here is one answer (One SQL Query that works)
select Model, Price
from Printer
where price = (select max(price) from Printer)
--
-Dick Christoph
"Daniel" <dtukkers@gmail.com> wrote in message
news:1143709387.198548.201780@z34g2000cwc.googlegroups.com...
> any place where you can find the answer of these exercies?
>
> im stuck at exercse 10:
>
> Exercise: 10
> Find the printers having the highest price.
> Result set: model, price.
>
> my query:
>
> select model, max(price)price from printer
>
> http://www.sql-ex.ru/exercises.php#answer_ref
>
> any place for the answers?
>
Navigation:
[Reply to this message]
|