SSLUG-msg00014.html

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

	Home		Subscribe		Mail Archive		Forum		Calendar		Search
	Date:				Thread:

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

To: sslug@sslug
Subject: Re: [PROGRAMMERING] [SQL] group by hjælp
From: Michael Rasmussen <sslug@sslug>
Date: Wed, 30 May 2007 20:48:22 +0200
Newsgroups: sslug.programmering
Organization: SSLUG
References: <f3kdi3$r5b$1@www.sslug.dk> <f3kdi3$r5b$1@www.sslug.dk> <20070530201256.580c2694@laptopia> <20070530201256.580c2694@laptopia> <f3kfpp$2dg$1@www.sslug.dk>
User-agent: Claws Mail 2.9.1cvs28

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

Follow-Ups:
- Re: [PROGRAMMERING] [SQL] group by hjælp
  - From: Kristian Nørgaard
- Re: [PROGRAMMERING] [SQL] group by hjælp
  - From: Jesper Krogh

References:
- [SQL] group by hjælp
  - From: Kristian Nørgaard
- Re: [PROGRAMMERING] [SQL] group by hjælp
  - From: Kim Schulz
- Re: [PROGRAMMERING] [SQL] group by hjælp
  - From: Søren Rasmussen

Prev by Date: Re: [PROGRAMMERING] [SQL] group by hjælp
Next by Date: Re: [PROGRAMMERING] [SQL] group by hjælp, Jesper Krogh
Previous by Thread: Re: [PROGRAMMERING] [SQL] group by hjælp
Next by Thread: Re: [PROGRAMMERING] [SQL] group by hjælp
Index(es)
- Date Index
- Thread Index

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