SQL question: How to select by keyword and returned dataset size ?
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