Re: [sqlite] Shortest time interval? [Was: Re: repeating events?]

[Allen Fowler]

> >
> > What am I missing here?  Am I doing the query wrong?
> 
> Yes. The "group by" doesn't know which rows to use for columns that  
> are not either aggregate functions (such as min) or grouped columns  
> (such as name). You know what min() does, but the query processor  
> doesn't.
> 

Ok, this I understand.

> You can do this in two steps by getting the min time length per name,  
> and joining that with the original table augmented with length.
> 

How should I go about this?


      

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users