Hi ,

I need some light on the following issue..

I have a table which has a date field proceed_data.
This table contains about past 6 months data.

I need to select fields from this table on a weekly basis.

I need out put as follows

row1- Week1 column1 column2 column 3 ...
row2- Week2 column1 column2 column 3 ...
row3- Week3 column1 column2 column 3 ...
...
...
Here number of weeks = Number of rows

Can I get using group by clause..or I need to use plsql tables ...

Thanks in Advance