convert a small query from sql server to mysql
Budget: €8 – €30 EUR
hi everyone, I have a small query written in SQL SERVER that should be converted to MySql ..
the query will be launched on a table of 60 million rows so it must be optimized
Delete from xTable where Cliente in
(select F1.Cliente From
(SELECT N=COUNT(CLIENTE),
Cliente
FROM XTABLE
GROUP BY CLIENTE
) F1
Inner join xTable on xTable.CLIENTE=F1.Cliente
Where f1.n>1 )
and isnull(xTable.Telefono,0)=0
the query will be launched on a table of 60 million rows so it must be optimized
Delete from xTable where Cliente in
(select F1.Cliente From
(SELECT N=COUNT(CLIENTE),
Cliente
FROM XTABLE
GROUP BY CLIENTE
) F1
Inner join xTable on xTable.CLIENTE=F1.Cliente
Where f1.n>1 )
and isnull(xTable.Telefono,0)=0