| order by month [message #132625] |
Mon, 15 August 2005 05:28  |
rzkhan
Messages: 370
Registered: March 2005
|
Senior Member |
|
|
salam.
I have a matrix report with the following fields
item_name as matrix_row_field,
month as matrix_column_field
sum(col1) as data
it displays the data as below
APR AUG JAN
ball point 2 4 5
I am working on how to order the month as below.
JAN APR AUG
ball point 5 2 4
my query is as below:
select to_char(issue_date,'MON')as month,
items_issued.item_id,
rpad(items.item_name,50),
sum(qty_issued) as total
from items_issued,items
where items.item_id=items_issued.item_id
and to_char(issue_date,'YYYY')='2005'
group by to_char(issue_date,'MON'),items_issued.item_id,rpad(items.item_name,50)
Please help me.. I need it urgently..thanks in advance
riaz
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
