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