Every derivedtable must have its own alias

Each derived table needs to have an alias

Change the MySQL statement to: select count (*) from (select * from…) as total

That’s it

Similar Posts:

• [Solved] MYSQL Error: “ Every derived table must have its own alias”
• sql Error: Every derived table must have its own alias [How to Solve]
• Every derived table must have its own alias
• You can’t specify target table for update….
• [Solved] sql Error: You can’t specify target table ‘tb_cr_circulate_gtsc’ for update in FROM clause
• [Solved] MYSQL Error: You can’t specify target table for update in FROM clause
• 12 Methods of SQL Error Injection [How to Inject]
• mysql 1142 – SELECT command denied to user ‘root_ssm’@’localhost’ for table …
• [Solved] MYSQL ERROR 1093 – You can’t specify target table ‘readbook’ for update in FROM clause
• [Solved] java.lang.Long cannot be cast to java.lang.Integer