db2 sql query

[sivanandang]

hi all,

i need single db2 sql query for bill range wise
eg. how many bill in
0 to 100.99 and
101 to 200.99 and
201 to 300.99

[r035198x]

hi all,

i need single db2 sql query for bill range wise
eg. how many bill in
0 to 100.99 and
101 to 200.99 and
201 to 300.99

Use between

[dewa81]

Do u need the results rangewise or you want to select those rows which are in this mentioned range? Or you want to find the count of number of rows satisfying each range in a single query?

[r035198x]

Do u need the results rangewise or you want to select those rows which are in this mentioned range? Or you want to find the count of number of rows satisfying each range in a single query?

Yep, I thought there could be something the OP didn't explain well there too. Let's see how it goes.