50分在线等,求一条检索语句！谢谢！

Question

数据表如下：PROJECT_TIME PROJECT_NAME
2006/9/22           水工程
2006/9/22          货工程
2006/9/23   亩工程
2006/9/23   图工程求一查询语句 输出的格式为
PROJECT_TIME     PROJECT_NAME1     PROJECT_NAME2     PROJECT_NAME3
2006/9/22          水工程             货工程2006/9/23         亩工程             图工程
...          

Answer 1

select PROJECT_TIME, PROJECT_NAME1, PROJECT_NAME2, PROJECT_NAME3 from (
select  PROJECT_TIME, PROJECT_NAME1, PROJECT_NAME2, PROJECT_NAME3, 
  row_number()over(partition by PROJECT_TIME order by PROJECT_NAME1 nulls last , PROJECT_NAME2 nulls last , PROJECT_NAME3 nulls last )as rn   from 
(select PROJECT_TIME, PROJECT_NAME as PROJECT_NAME1 , 
     lead(PROJECT_NAME,1,null)over(partition by PROJECT_TIME order by PROJECT_NAME) as PROJECT_NAME2,
     lead(PROJECT_NAME,2,null)over(partition by PROJECT_TIME order by PROJECT_NAME) as PROJECT_NAME3     
  from test_s )
  ) where rn = 1

Answer 2

xiaoxiao1984(笨猫儿) 的sql好象行的通！