Click here to Skip to main content
14,695,325 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi guys,

In Database, if i have Employees table which has more than 100 rows,
and i want to get rows form 41 to 50 only.

I try this:

select EmployeesName,EmployeesSalary from EmployeesTable

but it return all rows from table

I can not used EmployeesID in where clause because it not ordered as there are rows deleted from table as example EmployeesIDs can be like this:

1,2,4,5,6,8,10,13,14,15 There are 3,7,9,11,12 are deleted

So, i cannot depend on it

Then, what can i do ?
Updated 24-Apr-11 15:50pm
thatraja 24-Apr-11 23:08pm
Do you want rows or row count?(41 to 50...)
MrLonely_2 24-Apr-11 23:12pm
I want rows, man

1 solution

Take a look at the solutions posted here[^].
MrLonely_2 25-Apr-11 1:32am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900