display first few records

kskundan kskumar

Greenhorn

Posts: 1

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

manikandan murugaiyan

Greenhorn

Posts: 2

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

you can use

select * from table_name where rownum <51

It will return top 50 rows

Paul Sturrock

Bartender

Posts: 10336

I like...

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

"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!

JavaRanch FAQ HowToAskQuestionsOnJavaRanch

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.