SSLUG-msg00006.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: Kim Schulz <sslug@sslug>
Date: Sat, 2 Jun 2007 22:12:57 +0200
References: <f3kdi3$r5b$1@www.sslug.dk> <f3kdi3$r5b$1@www.sslug.dk> <f3rli2$peh$1@www.sslug.dk> <f3seii$fjv$1@shrek.krogh.cc>

On Sat, 2 Jun 2007 18:57:22 +0000 (UTC)
Jesper Krogh <sslug@sslug> wrote:

> Hvilket absolut er en bug i mysql.. 

vrøvl!! MIN er en aggregate function og returnerer resultatet af
funktionen kørt over en gruppe (i dette tilfælde hver
grupperingen efter navn). bemærk at det IKKE er pris den returnerer men
MIN(pris) - hvilket kolonne navnet også fint viser.

> Der findes ingen record i den oprindelige tabel der har id 1 og pris
> 180. Mysql returnerer data der ikke eksisterer. 

hvad med :
select id, navn, min(pris) from tabel 
Der vil du få samme min(pris) ud for alle rækker fordi den finder MIN
på tværs af gruppen (her alle rækker i "tabel")

-- 
    Kim Schulz       | Blog: http://www.schulz.dk/
Email: sslug@sslug | Work: http://www.devteam.dk/
Phone: +45 5190 4262 | Fun : http://www.chilifan.dk/

References:
- Re: [PROGRAMMERING] [SQL] group by hjælp
  - From: Niels Muller Larsen
- Re: [PROGRAMMERING] [SQL] group by hjælp
  - From: Jesper Krogh

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