67,516
社区成员
发帖
与我相关
我的任务
分享
with a as (select 'name' || rownum name,20*rownum score from dual connect by rownum < 7),
b as(select 'name' || rownum name, mod(rownum,3) class from dual connect by rownum <7)
select a.name,a.score,b.class from a, b where a.name = b.name