SQL Query

• santosh_sri

  Newbie

  Points: 4

  More actions

  April 19, 2002 at 10:08 am

  #78387

  How can I find out 6th Maximum salery from a table just using a normal SQl Query.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738773

  More actions

  April 19, 2002 at 10:20 am

  #427508

  select top 1

  from ( select top 6

  salary

  from salarytable

  order by salary desc

  ) a

  order by salary

  Steve Jones

  steve@dkranch.net