Hi:
How can I retrive the first few (ex. 30) raws from the table in which I don't know the where
condition.
Thanks.
Printable View
Hi:
How can I retrive the first few (ex. 30) raws from the table in which I don't know the where
condition.
Thanks.
select * fromwhere rownum <= 30 ;
02-13-2001, 08:59 PMmjitureply[QUOTE]Originally posted by ora_inf
[B]Hi:
How can I retrive the first few (ex. 30) raws from the table in which I don't know the where
condition.
u can use of rownum in query that will give u desire result;