How can I retrieve first few raws

[mjitu]

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