将表格中的数据查询出来成两列显示

张兴康 · 发表于 2020-4-17 16:02:04

--将表格中的数据成两列显示
select BB.*,EE.* FROM (
SELECT * FROM (SELECT rownum row_id,AA.* FROM (select ID,login_name,user_name from sa_staff_info order by ID) AA) WHERE row_id between 1 and 6 ) BB left join
(SELECT ROWNUM ROW_IDD, DD.* FROM (
SELECT * FROM (SELECT rownum row_id,CC.* FROM (select ID,login_name,user_name from sa_staff_info order by ID) CC) WHERE row_id between 7 and 10) DD) EE
on BB.ROW_ID = EE.ROW_IDD

复制代码

执行效果：