By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,585 Members | 2,235 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,585 IT Pros & Developers. It's quick & easy.

db2 sql query

P: 1
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
Jul 23 '07 #1
Share this Question
Share on Google+
3 Replies


10K+
P: 13,264
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
Jul 23 '07 #2

P: 14
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?
Jul 23 '07 #3

10K+
P: 13,264
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.
Jul 23 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.