I am making a horisontal bar chart, and I only need the top 10 results of my data set.
My code is as follows:
SELECT role_, COUNT(role_) as role_count FROM "*canvas" GROUP BY role_
ORDER BY role_count DESC
If I preview, it orders the output perfectly:
But when I add LIMIT 10 on my essql statement, it chooses 10 entries from the whole, and not the first 10:
I can't see any system in this, and using TOP 10 after SELECT gave an error.
Can someone please tell me what is going on with LIMIT?