Skip to content

Instantly share code, notes, and snippets.

@FabioRodrigues

FabioRodrigues/b.fix.sql

Last active June 18, 2019 12:25
Show Gist options
  • Save FabioRodrigues/3438deb61a25f9ec888c0b279b4e199b to your computer and use it in GitHub Desktop.
Save FabioRodrigues/3438deb61a25f9ec888c0b279b4e199b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
b.fix.sql
BEGIN TRAN
DELETE usuarioconhecimentoidioma
FROM usuarioconhecimentoidioma q
JOIN (SELECT c.idusuariomapeamento,
Max(c.ididioma) ididioma,
Count(*) qtd
FROM usuarioconhecimentoidioma c
JOIN usuariomapeamento um
ON c.idusuariomapeamento = um.id
JOIN login l
ON um.idlogin = l.id
GROUP BY c.idusuariomapeamento,
l.nomeusuario,
l.id
HAVING Count(*) > 2) t
ON q.idusuariomapeamento = t.idusuariomapeamento
AND q.ididioma = t.ididioma
--COMMIT
--ROLLBACK
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment