I'm sitting here banging my head trying to decide the subject for this post
because I don't know what I'd call what I want to do :)
Here's what I want to do but don't know how. The schema is simplified for
discussion.
CREATE TABLE program (time_received INTEGER, name TEXT);
Assume indices where
OK, it just hit me that I can use a subselect to get the 50th recorder
ordered by time and use a LIMIT 1 OFFSET 50 to get the time at that
location.
I should be be able to use that a MAX result.I hope.:)
--
View this message in context:
http://old.nabble.com/Imposinga-minimum-limit-on-
sorka wrote:
> I'm sitting here banging my head trying to decide the subject for
> this post because I don't know what I'd call what I want to do :)
>
> Here's what I want to do but don't know how. The schema is simplified
> for discussion.
>
> CREATE TABLE program (time_received INTEGER, name T
3 matches
Mail list logo