SELECT Temp.Numero,Temp.Link,Temp.TotalLink,Link.URL,LEN(ALLTRIM(Temp.Link)) AS LenLink
 FROM (SELECT MIN(Link.Numero) AS Numero,Link.Link,COUNT(*) AS TotalLink
 FROM Link GROUP BY 2) AS Temp
 INNER JOIN Link ON Temp.Numero=Link.Numero
 ORDER BY LenLink DESC