SSLUG-msg00017.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: Kristian Nørgaard <sslug@sslug>
Date: Wed, 30 May 2007 21:16:37 +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> <20070530204822.4ce967fe@localhost>
User-agent: Thunderbird 1.5.0.10 (X11/20070306)

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;


Hmmm, det har jeg svært ved at se skulle virke.
Måske virker det hvis der max er to priser for hver bog?

Men ellers...?

/ Kristian

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
- Re: [PROGRAMMERING] [SQL] group by hjælp
  - From: Michael Rasmussen

Prev by Date: Re: [PROGRAMMERING] [SQL] group by hjælp
Next by Date: Re: [PROGRAMMERING] [SQL] group by hjælp, Hans Schou
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] *