Query Help

• subhashkvsql

  Old Hand

  Points: 322

  More actions

  December 29, 2003 at 9:52 am

  #83622

  I have a table(More than 35000 records) having two columns 'Dates' and 'Price', i need to get the maximum price from the top 100 records order by dates desc. I wrote the query below

  Select top 100 max(price) from tab1

  but it is giving the maximum price out of the entire records, any suggestion ?

• jxflagg

  Hall of Fame

  Points: 3817

  More actions

  December 29, 2003 at 10:27 am

  #488008

  select max(price)

  from (

  select top 100 price

  from tab1

  order by dates desc) a