SQL question: How to select by keyword and returned dataset size ?

From: Charles Sun <csun_at_geneve.arc.nasa.gov>
Date: Mon, 18 May 1998 13:01:14 -0700
Message-ID: <3560938A.9528762F_at_geneve.arc.nasa.gov>



Hi,

I am new to SQL/Oracle8 and I have the following question:

I have a table with 2 fields (Date time_stamp, Double data) and I would like to
construct a query statement Query(Date start_time, Integer x) that will return

at most x records that are timestamped after the start_time. The rationale is that my Chart GUI can only display a limited size dataset.

Is there an easy way to do this ?

In a way, this output requirement is similar to the limited search results returned from web search engines such as Infoseek. However, these search engines use specialized database, not Oracle.

Thanks for any info.

Please reply by email, in addition to posting. Thank you.

Charles Sun
csun_at_geneve.arc.nasa.gov Received on Mon May 18 1998 - 22:01:14 CEST

Original text of this message