How to select 10-15 records?

[FishiFishi]

Hello everybody I have a table "Employee" which contains 20 records. i want to select records from 10 to 15. how can I select?

Regards, Qaiser Nadeem

[phantanagu]

You need to make a ID field in Employee table from 1 to 20 Then do this Select * from tblEmployee where ID in [10,15]

It seem to be a solution or an answer.

[Blue_Boy]

select * from Employee where [id] >= 10 and id <=15

---

I Love SQL

[kubben]

If you only want 10 of the 20 records you can do select top 10 * from yourtable Ben