when i am using "SELECT TOP 20 id FROM..." i get first 20 rows.<BR><BR>But I need rows from (ie.) 20 to 40! How SQL command looks in that case?<BR><BR>Tnx in advance!
has a solution for this (the LIMIT function)<BR><BR>access or sqlserver don't have this, so it's only possible with some nested selects<BR><BR>SELECT TOP 20 ID FROM<BR> (SELECT TOP 40 ID FROM TheTable ORDER BY ID DESC) as A<BR>ORDER BY ID
Danke, Garzie, Thanks, Hvala, Spasiba - Dutch! :-)