Se uso group by mi da errore:

Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause). Proccess Stopped ecc ecc

la query semplicissima è del tipo

select * from tabella where campo1 > 1 group by campo2