Skip to content

Instantly share code, notes, and snippets.

@FabioRodrigues

FabioRodrigues/b.sql

Last active June 18, 2019 11:48
Show Gist options
  • Save FabioRodrigues/e99f76878b0904d870e3b2e5f8bcf416 to your computer and use it in GitHub Desktop.
Save FabioRodrigues/e99f76878b0904d870e3b2e5f8bcf416 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
b.sql
select
c.IdUsuarioMapeamento
,l.NomeUsuario
,l.Id
,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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment