Re: OK wenn nicht vorhanden

[Thomas Wiedmann]

CREATE TABLE test_summe (
 id INT NOT NULL,
 menge INT NOT NULL
);

INSERT INTO test_summe VALUES
( 1, 0 ),
(10 , 10);


/* 1) vorhanden, menge = 0*/
SELECT id, SUM(menge) AS menge 
  FROM test_summe
GROUP BY id
HAVING SUM(menge) = 0;
+----------+-------+
| id       | menge |
+----------+-------+
|        1 |     0 |
+----------+-------+
1 row in set (0.08 sec)

 
/* 2) vorhanden, menge > 0 */
SELECT id, SUM(menge) AS menge 
  FROM test_summe
GROUP BY id
HAVING SUM(menge) > 0
+----+-------+
| id | menge |
+----+-------+
| 10 |    10 |
+----+-------+
1 row in set (0.00 sec)

 
/* 3) nicht vorhanden */
SELECT COUNT(*), SUM(menge) AS menge 
  FROM test_summe
 WHERE id = 100;
+----------+-------+
| COUNT(*) | menge |
+----------+-------+
|        0 |  NULL |
+----------+-------+
1 row in set (0.00 sec)

Ein paar kleine Beispiele dazu. Ansonsten hoffen wir, dass Dir morgen früh die ultimative Lösung einfällt.

Grüße
Thomas



Edited 1 time(s). Last edit at 10/31/2010 01:04PM by Thomas Wiedmann.