1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

How to only show results if count if more than 5

Discussão em 'StackOverflow' iniciado por fdantas, Junho 3, 2019.

  1. fdantas

    fdantas Administrator Moderador

    Is it possible to only show results where by the same cust-num appears more than 3 times.

    I have tried using a variable ( count = count + 1.). but its counting all the results .

    icount = kcount + 1.
    display
    cust-name cust-num state count



    Cust Num Name State Count
    1001 Apple NH 1
    1001 Apple NH 2
    1001 Apple NH 3
    1002 Orange BD 6
    1002 Orange BD 7
    1002 Orange BD 8
    1002 Orange BD 9

    Expected

    Cust Num Name State Count
    1001 Apple NH 1
    1002 Orange BD 2

    Continue reading...

Compartilhe esta Página