SSLUG-msg00013.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: Søren Rasmussen <sslug@sslug>
Date: Wed, 30 May 2007 20:29:14 +0200
Newsgroups: sslug.programmering
Organization: SSLUG
References: <f3kdi3$r5b$1@www.sslug.dk> <f3kdi3$r5b$1@www.sslug.dk> <20070530201256.580c2694@laptopia>
User-agent: Thunderbird 2.0.0.0 (Windows/20070326)

Kim Schulz skrev:

On Wed, 30 May 2007 19:50:58 +0200
Kristian Nørgaard <sslug@sslug> wrote:

Min SQL syntax er lidt rusten...
- hvordan får jeg en liste med alle bøgers billigste pris og salgsted?

Tabel:

--id-----bogtitel ------  salgsted ------ pris

1    'Linux A-Z'            'Amazon'    '200'
2    'Linux A-Z'            'Metro'        '180'
3    'Mit liv som tux'    'Bogladen'    '99'
4    'Mit liv som tux'     'Amazon'    '199'
5    'Nørder'                 'Metro'          '50'


svaret må gerne være MYSQL kompatibelt
/ Kristian

Mon ikke det er noget ala:

SELECT * FROM tabel GROUP BY bogtitle ORDER BY PRIS ASC.

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

/SR

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

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

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