把几行数据选成一行显示，不重复

为了让界面显示更多数据，业务需要把一个表的数据，在表格里面，一行显示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操作会把多于的数据过滤掉