List:General Discussion« Previous MessageNext Message »
From:tony Date:July 2 1999 4:40pm
Subject:Re: SELECT WHERE id = MAX(id)
View as plain text  
Paul Wolstenholme <wolstena@stripped> writes:
>SELECT max(id) as Max, id, amount from foo having id = Max

ERROR 1140: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is
illegal if there is no GROUP BY clause

Tony
-- 
-----------------------------------------------------------------------------
 Tony Bowden | tony@stripped               http://www.blackstar.co.uk/
  Black Star |    The UK's Biggest Video & DVD store * Free Postage Worldwide
-----------------------------------------------------------------------------
Thread
SELECT WHERE id = MAX(id)tony2 Jul
  • Re: SELECT WHERE id = MAX(id)Paul Wolstenholme2 Jul
    • Re: SELECT WHERE id = MAX(id)tony2 Jul
  • Re: SELECT WHERE id = MAX(id)Martin Ramsch2 Jul
    • Re: SELECT WHERE id = MAX(id)Steve Ruby2 Jul
Re: SELECT WHERE id = MAX(id)tony3 Jul
  • Re: SELECT WHERE id = MAX(id)Steve Ruby3 Jul