Re: convert ms sql query to mysql

[Damir Bulic]

SqlTran, our very advanced database translator migrated your SQL Server query to MySQL like this:


SELECT DISTINCT
UserID,
IP,
ROUND(COUNT(IP) / CAST((SELECT
COUNT(userid)
FROM
Users) AS DECIMAL(24)), 2) AS '%'
FROM
Users
GROUP BY
UserID, ip;

SqlTran does near-100% automated translation and migrates tables, data, procedures, functions, triggers, views...

You can learn more about SqlTran at www.sqltran.com

Damir Bulic
Spectral Core