Da li koristis GROUP BY klauzulu?
Predpostavimo da imamo tabelu pod imenom 'neka_tabela' sa jednim atributom 'neki_atribut'.
Upit:
Code:
SELECT COUNT(neki_atribut)
FROM neka_tabela
WHERE true = false
GROUP BY neki_atribut
ce vratiti rezultat NULL.
Upit:
Code:
SELECT COUNT(neki_atribut)
FROM neka_tabela
WHERE true = false
ce vratiti rezultat 0 (nula).
Chachka
"The best code is no code at all."
- Zidar (ES član)
"Biggest obstacle to learning
SQL is unlearning procedural
programming." - Joe
Celko
"Minimize code, maximize data."
- A. Neil Pappalardo