help needed on Rouding function and other things

From: Totti <saliba.toufic.george_at_gmail.com>
Date: Tue, 4 Dec 2007 23:33:59 -0800 (PST)
Message-ID: <a040a003-e2dc-42b8-8038-9b09b043c5cc@s19g2000prg.googlegroups.com>

CREATE TABLE SQL_TABL (

ORD_DATE        Date,
PROD_CODE       Varchar2(10),
CUST_CODE       Varchar2(10),
QTY                       Number(2),
UNIT_PRICE      Number(5,2),
SHIP_DATE       Date,
CARR_CODE       Varchar2(12),
SHIP_COST       Number(5,2),
PMT_DATE        Date

);

insert into SQL_TABL values ('08-Jan-05', 'A-50-0013', 'Cu-08-143', 4,
181.79, '09-Jan-05', 'TransCo', 60.27, '15-Jan-05');

insert into SQL_TABL values ('15-Jan-05', 'A-25-0753', 'Cu-08-180',
13, 265.61, '23-Jan-05', 'Expedit', 278.36, '29-Jan-05');
insert into SQL_TABL values ('19-Jan-05', 'A-24-0101', 'Cu-08-133',
20, 120.18, '22-Jan-05', 'Expedit', 188.28, '29-Jan-05');
insert into SQL_ASSGN_2 values ('30-Jan-05', 'B-63-0023', 'Cu-4-078',

4,
280.88, '09-Feb-05', 'Expedit', 92.93, '04-Feb-05');

hi every one i have a a table like such and i want to do 2 things

1.Produce total sales per Product Group interval (0-9, 10-19 etc) for sales made in 2006. Report only those groups which overall have total sales greater than 1500.

2.Produce total sales per Product Group interval (0-9, 10-19 etc) for sales made in 2006. Report only those groups where sales is more than 10% of grand total of sales.

the group code is the 2 digits between the - sign in the prod code i.e. A-50-0123 is of group 50 Group codes from 0 to 9 form Group0. Codes from 10 to 19 form Group10 etc. i know from excel that i need a rounding function to get them, but i dont know how to imply here in oracle

Any clues please on any of the two problems?? thanks in advance Received on Wed Dec 05 2007 - 01:33:59 CST