In this case you have to omit GROUP BY from your query.
Peter
On Tue, 19 Feb 2002, CreaCtion wrote:
> At 19.02.2002 10:20, you wrote:
> >What would you expect the database to return
> Thanks to all so far,
> The query should give the smallest price MIN(preis) and the according "lfd"
> num
At 19.02.2002 10:20, you wrote:
>What would you expect the database to return
Thanks to all so far,
The query should give the smallest price MIN(preis) and the according "lfd"
number of this record.
so the answer should only be one pair f.e.: 15200,00 | 41 . I think this
should work, as thi
Oliver,
>
> select min(preis),lfd from database where marke='marke'
> and typ not like 'R%'
> and typ not like 'X%'
> and typ not like 'C%'
> group by preis
>
> this doesn´t bring the expected pair "preis / lfd" but all available
> "preis/lfd" grouped ascending.
>
you're grouping by the same
On Tuesday 19 February 2002 10:07, Oliver Heinisch wrote:
What would you expect the database to return
You asked it to GROUP all the records with the same preis, that means it has
to choose a value for each column of the record that is the result of each
grouping, correct? So which of the
