Help needed in SQL!

[chrisrlong]

This is a standard 'windowing' problem. If you search this forum for WINDOW ROWNUM, you will find many threads on it.

Here is the standard wrapper for turning a statement into a windowed statement:

SELECT 
	OUTER.C1 
FROM 
	( 
		SELECT 
			INNER.C1, 
			ROWNUM 
				AS QUERY_ROWNUM 
		FROM 
			( 
			SELECT 
				C1 
			FROM 
				TABLE1 
			ORDER BY 
				C1 
			) INNER 
		WHERE 
			ROWNUM < 20
	) OUTER 
WHERE 
	OUTER.QUERY_ROWNUM >= 1

HTH,

- Chris