how to find the eigth highest value from a column

hi buddies,

can anyone help me to find out the eigth highest value from a column. i am using ms sql server 2005 express edition. can u suggest any methods other than sub queries

SELECT * FROM CompanyMaster WHERE CompanyID =(SELECT TOP 1 CompanyID FROM (SELECT TOP 8 CompanyID FROM CompanyMaster ORDER BY CompanyID DESC)

POSTED FROM : Jignesh Patel

select distinct value from table a where 8=(select count(distinct value) from table b where b.value >= a.value);

Select * from Employee E1
where (N-1) = (Select count(distinct(E2.Salary)) From Employee E2
Where E2.salary > E1.Salary)

*Replace N by the number required

Select a.colname from tblname a
where 8=(select count(distinct b.colname) from tblname b where a.colname<=b.colname )

Top 8 Bottom 1 I think