SELECT TOP 1 Name, AccountID FROM Character ORDER BY DESC, DESC, cLevel DESC, Experience DESC

SELECT TOP 1 Name, AccountID FROM Character ORDER BY cLevel DESC, Experience DESC

Você errou a sintaxe do comando.