You may want to understand what distinct and avg means. The
combination doesn't make sense.
Bob Rea schrieb am Samstag, 21. Juli 2001, 02:36:11:
> The SQL book I am using has this:
mysql>> select avg(distinct prod_price) as avg_price
> -> from Products
> -> where vend_id = 'dll01'
> -> ;
> and responds thus:
> ERROR 1064: You have an error in your SQL syntax near 'distinct
> prod_price) as avg_price
> from Products
> where vend_id = 'dll01'' at line 1
> How do I do this, if I can?
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php