I have this query
SELECT
nome,
cognome,
societa,
numero,
settore,
`1 bimestre`,
`2 bimestre`,
`3 bimestre`,
`4 bimestre`,
`5 bimestre`,
`6 bimestre`,
SUM(`1 bimestre`) + SUM(`2 bimestre`) + SUM(`3 bimestre`) + SUM(`4 bimestre`) + SUM(`5 bimestre`) + SUM(`6 bimestre`) AS Tot
FROM sim
GROUP BY numero
using rapid search box i have this error
Errore di tipo 256
Errore di descrizione Invalid use of group function
URL my-url/Costi_Sim_list.php?a=search&value=1&SearchFor=334&SearchOption=Contains&SearchField=
Errore di file C:\richiestasim\include\dbconnection.php
Errore di linea 34
Query SQL select count(*) from (SELECT nome, cognome, societa, numero, settore, `1 bimestre`, `2 bimestre`, `3 bimestre`, `4 bimestre`, `5 bimestre`, `6 bimestre`, SUM(`1 bimestre`) + SUM(`2 bimestre`) + SUM(`3 bimestre`) + SUM(`4 bimestre`) + SUM(`5 bimestre`) + SUM(`6 bimestre`) AS Tot FROM sim where 1=0 or upper(nome) like upper('%334%') or upper(cognome) like upper('%334%') or upper(societa) like upper('%334%') or upper(numero) like upper('%334%') or upper(settore) like upper('%334%') or upper(`1 bimestre`) like upper('%334%') or upper(`2 bimestre`) like upper('%334%') or upper(`3 bimestre`) like upper('%334%') or upper(`4 bimestre`) like upper('%334%') or upper(`5 bimestre`) like upper('%334%') or upper(`6 bimestre`) like upper('%334%') or SUM(`1 bimestre`) + SUM(`2 bimestre`) + SUM(`3 bimestre`) + SUM(`4 bimestre`) + SUM(`5 bimestre`) + SUM(`6 bimestre`) like '%334%' GROUP BY numero ) a