这两句查询为什么第一句不能运行,而第二句却能运行?

[cer]

(1).select * from (select * from package where package_id in (select package_id from package_items where tags like '%HTML%' group by package_id order by count(tags) desc) ) where rownum <=3
(2).select * from package where package_id in (select * from (select package_id from package_items where tags like '%HTML%' group by package_id order by count(tags) desc) where rownum <=3)

这两句为什么第一句不能运行,而第二句却能运行?

第一名提示为缺少右括号???

[cer]

qiaozhiwei(乔)
的办法可以考虑一下

[sasacat]

改成这样吧
SELECT *
FROM (SELECT package_id, COUNT (tags) COUNT
FROM package_items
WHERE tags LIKE '%HTML%'
GROUP BY package_id
ORDER BY COUNT DESC)
WHERE ROWNUM <= 3

[sasacat]

啊，写错了，应该是这样
SELECT *
FROM PACKAGE
WHERE package_id IN (
SELECT *
FROM (SELECT package_id
FROM package_items
WHERE tags LIKE '%HTML%'
GROUP BY package_id
ORDER BY COUNT (tags) DESC)
WHERE ROWNUM <= 3)

[sasacat]

再晕，这样不是跟你第二句一样吗....

你第一句不行的原因是 order by count(tags) desc在那个in子句里没有意义，oracle认为这样写是错的

[cer]

这就是第二种方法啊

[qiaozhiwei]

select *
from (
select *
from package
where package_id in (
select package_id
from (
select package_id
from package_items
where tags like '%HTML%'
group by package_id
order by count(tags) desc
)
)
)
where rownum <=3