added 100 characters in body

Source Link

edited Apr 8, 2019 at 6:26

reputation score 164844
10
10 gold badges
51
51 silver badges
85
85 bronze badges

I would like someone to provide me a suggestion.

Let's say I got data like this:

    Ref No      Whatever      Seq      Value
    A           Bla bla…      1        1 
    A           Bla bla…      2        1
    A           Bla bla…      3        0
    A           Bla bla…      4        1
    B           Bla bla…      5        0
    B           Bla bla…      6        1
    B           Bla bla…      7        0
    B           Bla bla…      8        1
    B           Bla bla…      9        0

How could I use SQL to get something like this?

    Ref No      Whatever      Value      Total
    A           Bla bla…      0          2
    B           Bla bla…      0          0
    B           Bla bla…      0          1
    B           Bla bla…      0          1

Basically try to filter based on Value = 0 and to count the no of records before that based on sorting of Seq.

Thank you.

I would like someone to provide me a suggestion.

Let's say I got data like this:

    Ref No      Whatever      Seq      Value
    A      Bla bla…      1      1
    A      Bla bla…      2      1
    A      Bla bla…      3      0
    A      Bla bla…      4      1
    B      Bla bla…      5      0
    B      Bla bla…      6      1
    B      Bla bla…      7      0
    B      Bla bla…      8      1
    B      Bla bla…      9      0

How could I use SQL to get something like this?

    Ref No      Whatever      Value      Total
    A      Bla bla…      0      2
    B      Bla bla…      0      0
    B      Bla bla…      0      1
    B      Bla bla…      0      1

Basically try to filter based on Value = 0 and to count the no of records before that based on sorting of Seq.

Thank you.

I would like someone to provide me a suggestion.

Let's say I got data like this:

    Ref No      Whatever      Seq      Value
    A           Bla bla…      1        1 
    A           Bla bla…      2        1
    A           Bla bla…      3        0
    A           Bla bla…      4        1
    B           Bla bla…      5        0
    B           Bla bla…      6        1
    B           Bla bla…      7        0
    B           Bla bla…      8        1
    B           Bla bla…      9        0

How could I use SQL to get something like this?

    Ref No      Whatever      Value      Total
    A           Bla bla…      0          2
    B           Bla bla…      0          0
    B           Bla bla…      0          1
    B           Bla bla…      0          1

Basically try to filter based on Value = 0 and to count the no of records before that based on sorting of Seq.

Thank you.

edited tags

Link

edited Apr 8, 2019 at 6:11

Trowa

reputation score 365
1
1 gold badge
6
6 silver badges
21
21 bronze badges

sql sql-server

Source Link

asked Apr 8, 2019 at 6:02

Trowa

reputation score 365
1
1 gold badge
6
6 silver badges
21
21 bronze badges

Count before and Group together

I would like someone to provide me a suggestion.

Let's say I got data like this:

    Ref No      Whatever      Seq      Value
    A      Bla bla…      1      1
    A      Bla bla…      2      1
    A      Bla bla…      3      0
    A      Bla bla…      4      1
    B      Bla bla…      5      0
    B      Bla bla…      6      1
    B      Bla bla…      7      0
    B      Bla bla…      8      1
    B      Bla bla…      9      0

How could I use SQL to get something like this?

    Ref No      Whatever      Value      Total
    A      Bla bla…      0      2
    B      Bla bla…      0      0
    B      Bla bla…      0      1
    B      Bla bla…      0      1

Basically try to filter based on Value = 0 and to count the no of records before that based on sorting of Seq.

Thank you.

sql-server

Collectives™ on Stack Overflow

Return to Question

Post Timeline

Count before and Group together