I'm trying to find the most common value from a single column
Code:
select first_name
from transaction_
group by first_name
order by count(*) desc
limit 1;
But I get an error instead
Error Code: 1114. The table 'C:\Windows\SERVIC~1\NETWOR~1\AppData\Local\Temp#sql53f4_33_26' is full
I tried searching for the given address but it says Windows can't find it.
Please help
