q7033686, MySQL - rextester

q7033686

Language: Layout:


absolute service time: 0,35 sec

edit mode | history

  
col1
col2
col3

1
water
22
NULL

2
water
3
NULL

3
water
5
NULL

4
air
10
NULL

5
earth
3
NULL

6
air
5
NULL


  
col1
sum_col2

1
air
15

2
earth
3

3
water
30


  
col1
col2
col3

1
water
22
30

2
water
3
30

3
water
5
30

4
air
10
15

5
earth
3
3

6
air
5
15

λ

                                      .NET NoSQL database for rapid development