how to write the query to select 10 record from database

[Rmesh]

how to write the query to select 10 record from database

[Not Active]

Depends where the 10 records are. SELECT TOP 10 will get the first ten records matching the criteria. If you want 10 records in teh middle or end then you have more work to do.

---

only two letters away from being an asset

[sanjaybs2001]

Select top 10 * from

[Rmesh]

ok how to get next 10 records from table ?how to write query to get it

[sanjaybs2001]

You need to retrive 20 records and ignore top 10 to get next 10 records

[sanjaybs2001]

or Select top 10 * from agent where agentid not in (select top 10 agentid from agent)