SQL Query MAX, MIN and AVG

I seem to be getting an error stating there is LIMIT 0 to 1000 when I apply the MAX or MIN operators. Any idea why this is happening?

This is happening after restoring the database. If anyone has had a similar problem please do let me know.


The second last message has nothing to do with your query. You likely opened the invoices table in Workbench at 21:14:16 and have automatic row limiting active. Theres a green hook next to the message so everything was fine.

The last message is an error message related to your query. You have a space between MAX and the opening parenthesis. Delete that and you’ll be fine.

1 Like

Thanks Sam! Sorry for the delayed response!