Eliminar registros duplicados sin GROUP BY

[Libras]

mi mistake:

Código SQL:

SELECT * FROM(
SELECT ROW_NUMBER() OVER(partition BY a.gl_no ORDER BY a.gl_no) AS rn, a.* FROM F_GLOSSAIRE AS A 
LEFT JOIN F_ARTGLOSS AS B ON A.GL_No = B.GL_No 
WHERE A.GL_No = '441'
) t1 WHERE rn=1
 

saludos!