display first few records

[kskundan kskumar]

how can i display first fifty records from a table in oracle

[manikandan murugaiyan]

you can use

select * from table_name where rownum <51

It will return top 50 rows

[Paul Sturrock]

"abcabc abc"

Welcome to JavaRanch!

Thanks for taking the time to answer a question. Please update your display name so it complies with our Naming Policy. You can do this here. Thanks!