467,201 Members | 1,055 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,201 developers. It's quick & easy.

db2 sql query

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
  • viewed: 1656
Share:
3 Replies
8TB
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
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
8TB
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.

Similar topics

2 posts views Thread by jaysonsch | last post: by
9 posts views Thread by netpurpose | last post: by
3 posts views Thread by Harvey | last post: by
4 posts views Thread by Diamondback | last post: by
14 posts views Thread by Dave Thomas | last post: by
4 posts views Thread by Stan | last post: by
6 posts views Thread by jsacrey@comcast.net | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.