[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 Michael Rasmussen:
>  On Wed, 30 May 2007 20:29:14 +0200
>  Søren Rasmussen <sslug@sslug> wrote:
> 
> > Hvis jeg husker korrekt vil det resultere i at den først sorterer
> > efter at have grupperet. Det vil give noget a la:
> > 
> > 5	Nørder		Metro		50
> > 3	Mit liv som tux	Bogladen	99
> > 1	Linux A-Z	Amazon		200
> > 
>  Ja, man skal ind i noget self join, hvor pris bliver
>  udvælgelseskriteriet. Et eksempel:
>  select a.bogtitel, a.salgsted, a.pris from bog a, bog b where a.pris <
>  b.pris group by bogtitel;

Den fejler, hvis der kun er en record for hver bog.. så kommer den slet
ikke med ud. 

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-06-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] *