他的回复:
补充:测试了一下组合使用,按照官方文档,下面的语句应该都是符合语法的。但是有些错误,有些正确。 // 语法正确 select eol1_0.id,eol1_0.name from EntityOfLists eol1_0 where eol1_0.id=1 union all select eol2_0.id,eol2_0.name from EntityOfLists eol2_0 where eol2_0.id=1 order by 1 // 语法错误 select eol1_0.id,eol1_0.name from EntityOfLists eol1_0 where eol1_0.id=1 union all select eol2_0.id,eol2_0.name from EntityOfLists eol2_0 where eol2_0.id=1 order by 1 offset 0 fetch first 1 rows only // 语法正确 select eol1_0.id,eol1_0.name from EntityOfLists eol1_0 where eol1_0.id=1 union all select eol2_0.id,eol2_0.name from EntityOfLists eol2_0 where eol2_0.id=1 offset 0 fetch first 1 rows only // 语法错误 select eol1_0.id,eol1_0.name from EntityOfLists eol1_0 where eol1_0.id=1 union all select eol2_0.id,eol2_0.name from EntityOfLists eol2_0 where eol2_0.id=1 fetch first 1 rows only