Re: [sqlite] sqlite-users Digest, Vol 24, Issue 12

Florian Schricker wrote: > select OPER, PRODUCT, CATEGORY, NAME, [...], VALUE, TEXT, > max(CREATETS) as CREATETS > from table > where oper = 'myOper' and product = 'myProduct' and Category = > 'myCategory' group by OPER, PRODUCT, CATEGOY, NAME order by CREATETS > desc > >

Re: [sqlite] sqlite-users Digest, Vol 24, Issue 12

On 14 Dec 2009, at 8:52am, Florian Schricker wrote: >>> Primary keys are Oper, Product, Category, Name and CreateTS >> There is only one primary key per table. > > So to say the primary key is "Oper, Product, Category, Name, CreateTS". No. Go read a boos on databases. The shorter your

Re: [sqlite] sqlite-users Digest, Vol 24, Issue 12

Hi everyone, first off thanks to everyone for replying to my answer! On Sat, Dec 12, 2009 at 1:00 PM, wrote: >   7. Re: SQL question (Pavel Ivanov) >   8. Re: SQL question (Rich Shepard) >  10. Re: SQL question (Igor Tandetnik) >  11. Re: SQL question (Simon