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 ?