0

table

I tried:

select time_spent,language as languages ,
        round(100*count(language)/total,2) as percentage 
from job_data
    cross  join(
                select count(*) as total from Job_data
                ) a
group by 1,2 ;

but i got error

LIMIT 0, 50000 Error Code: 1055. Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a.total' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 0.000 sec

RiggsFolly
  • 93,638
  • 21
  • 103
  • 149

0 Answers0