I have table with data as below
columnname: name| start_time| download_time
row1: 'Home Page'| '2009-09-23 00:06:28'| 25
row2: 'Hotmail Home Page'| '2009-09-21 14:20:20'| 25
row3: 'Logout Page'| '2009-09-23 00:06:28'| 1
row4: 'Netbanking After Login Page'| '2009-09-23 00:06:28'| 6
row5: 'Home Page'| '2009-09-23 00:08:53'| 0
row6: 'Netbanking After Login Page'| '2009-09-23 00:08:53'| 0

i have to transpose this table in to something like this.


columnnames: name |2009-09-23 00:06:28 | 2009-09-23 00:08:53 |2009-09-23 00:11:01
row1 'Home Page' | 25 | 0 | 0
row2 'Hotmail Home Page'| 0 |0|0
row3 'Logout Page'| 1| 0| 0
row4 'Netbanking After Login Page' | 6| 0| 0


this i could achive using below select statement.
select s.name,
SUM(case when s.start_time= '2009-09-23 00:06:28' then s.download_time end) as '2009-09-23 00:06:28',
SUM(case when s.start_time= '2009-09-23 00:08:53' then s.download_time end) as '2009-09-23 00:08:53',
SUM(case when s.start_time= '2009-09-23 00:08:53' then s.download_time end) as '2009-09-23 00:11:01'
from script_info s group by s.name


Now i want to map this in hibernate. how i can do this?

Best Regards
krishna

Hi,
I don't know what database you are using. Does your database support column names with dashes and colons (2009-09-23 00:06:28)? Also is'nt it that the column names are dynamic as they represent timestamp?
Not sure what you are trying to do.
-Srilatha.