SELECT TOP 5 column FROM table
ORDER BY NEWID()

set rowcount 5

select * from table_name

select top5 * from table
minus
select top4 from table

SELECT TOP 1 Empid  
    FROM (SELECT DISTINCT TOP 6 Empid FROM Employees ORDER
BY Empid desc) a  ORDER BY Empid asc

select top 1 * from table_name where id in(select top 5 id 
from table_name order by desc)

select top 1 * from  table_name
where id in (select top 5 id from table_name order by id asc)
order by id desc

all the answers are wrong,the questions is  like this there 
are 100 rows they want o/p to display is in betwwen 50 and 
100 are displayed


      select top 100 * from  tablename where empid not in( 
select top 50 empid from  TABLENAME)

this is uma sorry the above is wrong.


pls the is the correct answer ,i have this answer

declare cursor on table ,after that open the cusor and 
using "fetch" keyword we retrive any row ,and we have 
remove the cursor explictly because it is stored in the 
memory pls use dellocate keyword


declare cursou_emp2 insensitive scroll cursor for select * 
from empdetails [for{readonly}]

open cursou_emp2


fetch absolute 15 from cursou_emp2


deallocate cursou_emp2




it will display 15th row, if u wnt any row u chnage instead 
of 15