Click here to Skip to main content
15,899,679 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 ?
Posted
Updated 24-Apr-11 14:50pm
v4
Comments
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[^].
 
Share this answer
 
Comments
MrLonely_2 25-Apr-11 1:32am    
Thanks

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