Difference between revisions of "Dvě a více výpůjček"
From Wikivyuka
m |
m |
||
| Line 1: | Line 1: | ||
| − | SELECT COUNT(VYPUJCKA.c_cten) AS pocet, c_cten | + | SELECT COUNT(VYPUJCKA.c_cten) AS pocet, c_cten |
| − | FROM VYPUJCKA | + | FROM VYPUJCKA |
| − | GROUP BY c_cten | + | GROUP BY c_cten |
| − | HAVING COUNT(VYPUJCKA.c_cten) >= 2 ; | + | HAVING COUNT(VYPUJCKA.c_cten) >= 2 ; |
| + | |||
| + | [http://gis.vsb.cz/wikivyuka/index.php/Dotazy Zpět na stránku Dotazy] | ||
| + | |||
| + | [http://gis.vsb.cz/wikivyuka/index.php/%C3%9Alohy_k_procvi%C4%8Dov%C3%A1n%C3%AD_u%C4%8Diva Zpět na stránku Úlohy k procvičení] | ||
Latest revision as of 12:13, 5 December 2011
SELECT COUNT(VYPUJCKA.c_cten) AS pocet, c_cten FROM VYPUJCKA GROUP BY c_cten HAVING COUNT(VYPUJCKA.c_cten) >= 2 ;
