Home > Blockchain >  SQL - an alias was previously found when using over() in old mysql version
SQL - an alias was previously found when using over() in old mysql version

Time:06-14

A sql query didn't work in old version of mysql below 8:

SELECT count(*) OVER() AS d FROM `T`

It gives this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() AS FULLCOUNT FROM T' at line 1

You can refer to this DBFiddle:

https://dbfiddle.uk/?rdbms=mysql_5.7&fiddle=7dd651e5b2c988a7a85c76a2c83df066

to test the query with different versions.

then tell me how can I solve that issue without upgrade mysql version because I don't have access of that server

CodePudding user response:

This way :

SELECT (select COUNT(*)  as d FROM T) as d
FROM T;

DEMO

  • Related