PDA

Click to See Complete Forum and Search --> : 2 problems with SQL statments

DanyDin
May 17th, 2002, 06:20 PM
Manish Malik
May 17th, 2002, 07:30 PM
homework problems? :)
Peter Garmidolov
May 18th, 2002, 03:16 AM
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;