Mailinglisten-Archive

Re: Abfrage Problem

Archiv Mailingliste mysql-de

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Abfrage Problem

Subject: Re: Abfrage Problem
From: "Cyrill Schumacher" <webmasterbhs_(at)_bluewin.de>
Date: Wed, 20 Dec 2000 23:17:44 +0100
Content-Transfer-Encoding: 8bit
Old-Return-Path: <webmasterbhs_(at)_bluewin.de>
Organization: www.bhsbinkert.com - www.koi-hobby.de
References: <000501c06acf$be88ba20$0165a8c0_(at)_s266>
Reply-To: "Cyrill Schumacher" <kiri_(at)_swol.de>

> Wie muss die Abfrage aussehen wenn ich die Ausgabe:
> "Tasse, Teller, Topf" haben möchte, also immer nur
> eines der Felder?

select distinct(tellerspalte) as dt,count(tellerspalte) as ct
from tabelle group by dt order by ct desc,dt asc


kiri


---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql

References:
- Abfrage Problem
  - From: "Dietmar Winhold" <SSD-DiWi_(at)_T-Online.de>

Prev by Date: RE: Abfrage Problem
Next by Date: RE: Abfrage Problem
Prev by thread: Re: Abfrage Problem
Next by thread: RE: Abfrage Problem
Index(es):
- Date
- Thread

Home | Main Index | Thread Index

php::bar PHP Wiki - Listenarchive