|
Тема |
GROUP BY Clause проблем |
|
Автор | ddd (Нерегистриран) | |
Публикувано | 06.07.04 11:37 |
|
|
SELECT * from t1 WHERE cType IN ('1234567891'
,'BOX','PALLET') GROUP BY cType ORDER BY cID
(в МS SQL)
ми дава грешка "Column 't1.c1' is invalid in the select list because it
is not contained in either an aggregate function or the GROUP BY clause."
И същото за всички column-и.
A за синтаксиса на груп бай прочетох:
The SQL synthax emposes the restriction that,whenever the GROUP BY clause is used ,the attributes that can appear in the select list must be a subset of the attributes used in the group clause.Refferences to these attributes are possible because each tuple of the group will be characterized by the same values.
Tова значи ли че не мога да селектна всичко а да групирам само по едно???!!
|
| |
|
|
|