把几行数据选成一行显示，不重复
为了让界面显示更多数据，业务需要把一个表的数据，在表格里面，一行显示3条数据。。。。。
?
比如
c1 c2?
1 ? 2
3 ? 4
5 ? 6
7 ? 8
要显示成
c11 c12 c21 c22 c31 c32
1 ? ? ?2 ? ?3 ? ? 4 ? ?5 ? ? 6
7 ? ? ?8
?
?
想了半天，用rownum解决了这个问题，代码如下：
select num1, storage_no1, storage_name1, num2,storage_no2, storage_name2 ,num3,storage_no3, storage_name3 ?from?
(select * from?
?? ? ? ?(select rownum as num1, storage_no as storage_no1, storage_name as storage_name1 from Base_Storage where
?? ? ? ? ? ? ? ?Base_Storage.Area_No='H'
?? ? ? ?) b1
?? ? ? ? ? ? ? ?left join
?? ? ? ?(select rownum as num2, storage_no as storage_no2, storage_name as storage_name2 from Base_Storage where
?? ? ? ? ? ? ? ?Base_Storage.Area_No='H'
?? ? ? ? ) b2
on (b1.num1+1)=b2.num2) t1
left join
(select rownum as num3, storage_no as storage_no3, storage_name as storage_name3 from Base_Storage where
?? ? ? ? ? ? ? ?Base_Storage.Area_No='H'
?? ? ? ? ) b3
on (t1.num2+1)=b3.num3
where ?mod( t1.num1,3)=1
?
最后这个mod 3操作会把多于的数据过滤掉
