[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [PROGRAMMERING] [SQL] group by hjælp



I sslug.programmering, skrev Martin Møller Skarbiniks Pedersen:
> > >  mysql> select id,bogtitel,salgssted,min(pris) from t2 group by bogtitel;
> 
>  Er det overhovedet lovligt SQL ? Det virker ihvertfalde ikke på en
>  Oracle 8 (hvilket også er gammel).
> 
> 
>  SQL> select id,bogtitel,salgssted,min(pris) from t2 group by bogtitel;
>  select id,bogtitel,salgssted,min(pris) from t2 group by bogtitel
>         *
>  ERROR at line 1:
>  ORA-00979: not a GROUP BY expression

Og heller ikke i postgresql.. som sagt .. en bug i mysql. 

Jesper

-- 
./Jesper Krogh, sslug@sslug, Jabber ID: sslug@sslug



 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2007-07-01, 02:01 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *