HC_

VS

HC_
Mar 11th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. SELECT TOP 10 RUT_CLIENTE
  2. , COUNT(DISTINCT IdProducto) PRODUCTOS
  3. , COUNT(1) MOVIMIENTOS
  4.  
  5. FROM dbo.st_CL_FlujoNeto
  6. WHERE PERIODO > 201700
  7. AND DEFINICION IN('APORTE','RESCATE')
  8. AND LTRIM(RTRIM(MONTO_PESOS_FINAL)) != 'NULL'
  9. AND CAST(SUBSTRING(RUT_CLIENTE,1,LEN(RUT_CLIENTE) -1) AS INT) <= 20000000
  10. AND RUT_CLIENTE != 'NULL'
  11. --AND DEFINICION != 'NEUTRO'
  12. GROUP BY RUT_CLIENTE
  13. HAVING COUNT(DISTINCT IdProducto) > 2
  14. ORDER BY COUNT(1) DESC
Add Comment
Please, Sign In to add comment