sql - 选择语句上的SQL内部联接

Question

我试图对这样的选择语句进行内部联接:

select *
from (select* from bars  where rownum <= 10 )as tab1
inner join (select * from bars  where rownum <= 10 )as tab2
on tab1.close=tab2.close

我收到以下错误:
ORA-00933 SQL命令未正确结束
任何帮助，将不胜感激，谢谢!

Answer 1

只需从查询中删除as即可:

select *
from (select* from bars  where rownum <= 10 ) tab1
inner join (select * from bars  where rownum <= 10 ) tab2
on tab1.close=tab2.close