[sqlite] Imposinga minimum limit on a select. Anyway to do this?

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

Re: [sqlite] Imposinga minimum limit on a select. Anyway to do this?

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-

Re: [sqlite] Imposinga minimum limit on a select. Anyway to do this?

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