RE: [sqlite] Re: Why it does not work properly?

: Why it does not work properly? woj <[EMAIL PROTECTED]> wrote: > Thank's for your reply. I didnt realize this, but of course it is > logical. So, now I think how to select not only one row (what seems > to be easy) but set of rows from previously mentioned data where only > the

Re: [sqlite] Re: Why it does not work properly?

Thank's for your reply. I didnt realize this, but of course it is logical. So, now I think how to select not only one row (what seems to be easy) but set of rows from previously mentioned data where only these rows are picked up with largest Data value for each IdMat, so correct version of

Re: [sqlite] Re: Why it does not work properly?

--- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > woj <[EMAIL PROTECTED]> wrote: > > Now, when I run a query: > > SELECT Mieszalnia.IdMat, Mieszalnia.Partia, Mieszalnia.Kont, > > Mieszalnia.Uk, Max(Mieszalnia.Data) FROM Mieszalnia; > > I always get: > > IdMat Partia KontUk Data > > 6