|
-
May 17th, 2002, 06:20 PM
#1
2 problems with SQL statments
Last edited by DanyDin; May 19th, 2002 at 11:35 AM.
-
May 17th, 2002, 07:30 PM
#2
homework problems? 
-
May 18th, 2002, 03:16 AM
#3
the simpliest way for point 1:
select count(*), 'Group 1' from article where sell_pr between 0 and 100
union
select count(*), 'Group 2' from article where sell_pr between 101 and 200
union
select count(*), 'Group 3' from article where sell_pr between 201 and 300;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
