oracle中运行sql语句提示未找到要求的from关键字，下面是我写的sql，大家帮我看下
select*from(selecta.*rownumrfrom(selectu.*,hu.unitTitle,s.statetitlefromHJS_Unituleft...
select * from(
select a.* rownum r from (
select u.* , hu.unitTitle ,s.statetitle from HJS_Unit u
left join hjs_unit hu on u.hjs_unitcode = hu.unitcode
inner join hjd_state s on u.stateid =s.stateid
order by to_number(u.unitcode)
)a
) where r between 1 and 4 展开
select a.* rownum r from (
select u.* , hu.unitTitle ,s.statetitle from HJS_Unit u
left join hjs_unit hu on u.hjs_unitcode = hu.unitcode
inner join hjd_state s on u.stateid =s.stateid
order by to_number(u.unitcode)
)a
) where r between 1 and 4 展开
1个回答
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
