-
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 * from <table> where rownum <= 30 ;
-
reply
[QUOTE][i]Originally posted by ora_inf [/i]
[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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|