Re: SQL info

Praveen Rao (rao_at_ee.uwm.edu) wrote:

: Try
: 	select * from table
: 		where rownum < 51 ;

Hi again,

        when I started to implement that in my program, I notest that the
"rownum" is assigned before any "order" clause. So, when I do

		select * from table
		where rownum < 5
		order by column_a;

	what I get is a order by column_a for the first 5 ocorrences, by order

        Is there any way for doing the "order" and after that the condition
"rownum < 5" ? or... I will have to do that in Pro*C?

Thanks for any answer,

        Ana Received on Mon Sep 04 1995 - 00:00:00 CEST