应该怎么写

[arthurzhujie]

select max(count(*)) ，title into :z,:name from tablename

where tablename.bookid=(select bookid from tablename );

挑处tablename 表中bookid一样得项得最大值和 名称

是这么写吗？


听说聚集函数不能嵌套 max(count(*)) 不对

能够由什么办发实现在count（*）这个集力再查询呢？

[dukejx]

select bookid, title
from tablename
where bookid= (select max(bookid) from tablename)