Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select top 20
- ld.Artigo
- ,count(ld.Artigo)
- ,sum(ld.TotalIliquido)
- from
- dbo.CabecDoc as cd
- inner join
- dbo.LinhasDoc as ld
- on ld.IdCabecDoc = cd.Id
- inner join
- dbo.DocumentosVenda as dv
- on dv.Documento = cd.TipoDoc
- inner join
- dbo.Artigo as a
- on a.Artigo = ld.Artigo
- where
- dv.TipoDocumento >= 4
- group by ld.Artigo
- order by count(ld.Artigo) desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement