Am 18.10.2012 12:57, schrieb Olaf Kluge: > Sorry, > > > > where teilenr = a.teilenr of course… > > > > > > Hello everybody, > > today perhaps I have a simple question. > > In a table there are the following fields: > > Partnumber; quantity; price > > ABC; 1; 115€ > > ABC; 10; 100€ > > ABC; 20; 80€ > > Now I would like one sql-query-result, the price for the greatest quantity. > > I have the following: > > SELECT PREIS > > FROM TSTAFFELPREISE a where > > TEILENR ='210094LG' and vanz = (select max(vanz) from tstaffelpreise where > teilenr
How about: SELECT FIRST 1 PREIS FROM TSTAFFELPREISE where TEILENR ='210094LG' ORDER BY VANZ DESC
