• Try this.

    select top 1 PRICE

    from table1

    order by price desc