what dastabase? you could do it it in a stored proc with a loop
"Michael Lugassy" <[EMAIL PROTECTED]> wrote:
Is it possible to SQL-SELECT a specific number of rows from between the result
set.
NOT by using the BETWEEN keyword in the WHERE clause, but by choosing
to select only rows x through y.
let's say I have this results set
personID personNAME
1 Michael
2 Roman
3 David
4 Ilia
5 Uri
I want to get Roman till Ilia, WITHOUT specifiying - WHERE personID BETWEEN 2
AND 4
but Specifying something liek:
SELECT ROWS 2 TILL 4 FROM personalls (without personID, which I want to get!)
Is this possible?
Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
