Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP 10 RUT_CLIENTE
- , COUNT(DISTINCT IdProducto) PRODUCTOS
- , COUNT(1) MOVIMIENTOS
- FROM dbo.st_CL_FlujoNeto
- WHERE PERIODO > 201700
- AND DEFINICION IN('APORTE','RESCATE')
- AND LTRIM(RTRIM(MONTO_PESOS_FINAL)) != 'NULL'
- AND CAST(SUBSTRING(RUT_CLIENTE,1,LEN(RUT_CLIENTE) -1) AS INT) <= 20000000
- AND RUT_CLIENTE != 'NULL'
- --AND DEFINICION != 'NEUTRO'
- GROUP BY RUT_CLIENTE
- HAVING COUNT(DISTINCT IdProducto) > 2
- ORDER BY COUNT(1) DESC
Add Comment
Please, Sign In to add comment