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
