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 ;
[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;