Hi Vinay,

You can write the following query if you want to extract 2nd /3rd /4th record from the sql query ....

Say for example you are having 2 tables .....
1. EmpMaster (contains list of all employees)
2. EmpDept (contains information about employee department)

Now say for instance you need to fetch 2th record then you can use the following query .....

select top 1 qry.empid, qry.empfname,...