SELECT COUNT(1) AS loot FROM tblname WHERE uid = xx AND item_id != 0; SELECT COUNT(1) AS spent FROM tblname WHERE uid = xx AND item_id = 0 AND mod_value < 0
Da się wyjąć te county w jednym zapytaniu?
SELECT (SELECT COUNT(1) FROM tblname WHERE uid = xx AND item_id != 0) AS loot, (SELECT COUNT(1) FROM tblname WHERE uid = xx AND item_id = 0 AND mod_value < 0) AS spent
SELECT Count(CASE WHEN item_id<>0 THEN item_id END) AS loot, Count(CASE WHEN item_id=0 AND mod_value<0 THEN item_id END) AS spent FROM tblname WHERE uid=xx
SELECT ( SELECT count(`Wynik`) FROM `Historia2` WHERE `Wynik`="Zdany" ) AS Zdanych, ( SELECT count(`Wynik`) FROM `Historia2` WHERE `Wynik`="Oblany" ) AS Oblanych
SELECT Pracownik, ( SELECT count(`Wynik`) FROM `Historia2` WHERE `Wynik`="Zdany" ) AS Zdanych, ( SELECT count(`Wynik`) FROM `Historia2` WHERE `Wynik`="Oblany" ) AS Oblanych FROM `Historia2` GROUP BY `Historia2`
SELECT count(`Wynik`) FROM `Historia2` WHERE `Wynik`="Zdany"
SELECT Pracownik, Count(Case When Wynik='Zdany' then Wynik end), Count(Case When Wynik='Oblany' Then wynik end) FROM Historia2 GROUP BY 1