[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



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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;

- -- 
Hilsen/Regards
Michael Rasmussen
http://keyserver.veridis.com:11371/pks/lookup?op=get&search=0xE3E80917
A computer is like air conditioning: it becomes useless when you open
windows.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGXcb2VErYVePoCRcRAgCHAJ9CS48J0hjK7wzRd7Er10ucj4D2WQCgnHSY
S+vtBQof64K4HdQ81cH77xs=
=UyaN
-----END PGP SIGNATURE-----


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