March 5, 2014 at 10:00 pm
Please help me in doing this exercise.
ItemIDItemNamePrice
1Item1120.00
2Item2234.00
3Item3250.00
4Item4300.00
5Item5300.00
6Item6290.00
7Item7170.00
8Item890.00
9Item9170.00
the above is the existing table
and i need a query to retrieve max price with out using max function and sub query
Target is to write SQL statement within 60 characters.
March 5, 2014 at 11:30 pm
Try this.
select top 1 PRICE
from table1
order by price desc
March 5, 2014 at 11:57 pm
looks like an assignment question to me 🙂
March 26, 2014 at 12:57 am
Select top 1 price from table_name order by price desc
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply