create proc GetBookStatisticInfo
as
select BookName,ISBN,Publisher,
    总数=count(1)
from tb
group by BookName,ISBN,Publisher
go

------解决方案--------------------
探讨

创建存储过程GetBookStatisticInfo
输入参数：无
功能：按BookName,ISBN,Publisher分组统计图书总数，给出（BookName,ISBN,Publisher，总数）信息。


------解决方案--------------------
其实,你这个没必要用储存过程,直接SQL语句即可.
SQL code
select BookName,ISBN,Publisher,count(1) 总数 from tb group by BookName,ISBN,Publisher

------解决方案--------------------
SQL code
create procedure GetBookStatisticInfo
as
begin
  select BookName,ISBN,Publisher,count(1)as 总数 from tb group by BookName,ISBN,Publisher
end